tag:blogger.com,1999:blog-75803182708377142762024-02-07T13:19:06.909+05:30OracleAppsTodayAll about Oracle Apps. API examples, Codes and tweaks, Commands, Tips and TricksAnonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.comBlogger116125tag:blogger.com,1999:blog-7580318270837714276.post-13233598023961081212015-08-07T12:29:00.000+05:302015-08-07T12:29:53.075+05:30Query to Derive Customer Number, Site Use ID from Customer Bank Account Number
SELECT hca.account_number,
hcsu.site_use_id,
hca.cust_account_id
INTO l_customer_number,
l_cust_site_use_id,
l_cust_account_id
FROM hz_cust_accounts_all hca,
hz_cust_acct_sites_all hcas,
hz_cust_site_uses_all hcsu,
IBY_ACCOUNT_OWNERS IAO,
IBY_EXT_BANK_ACCOUNTS IEBA
WHERE hca.cust_account_id = hcas.cust_account_id
AND hca.party_id = iao.account_owner_party_id
AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
AND hcas.org_id = <Org_ID>
AND hca.status = 'A'
AND hcas.status = 'A'
AND hcsu.status = 'A'
AND hcas.bill_to_flag = 'P'
AND NVL (IAO.end_date, SYSDATE + 1) > SYSDATE
AND ieba.bank_account_num = <Bank Account Number>
AND iao.ext_bank_account_id = ieba.ext_bank_account_id;Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-10296222301060737262015-06-23T10:00:00.000+05:302015-06-24T16:48:20.230+05:30Oracle Apps : Steps to Implement Employee/Supervisor Approval HierarchyPurchasing-> Setup-> Organization-> Financial Options
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgR72L5bD_1Tx5gkfFybmExFfnuOGlc5u__7fW5VF6_tAybpUKD_uwhgIpuEd2gLUg23_8yUjG6bF8DMOPuxS_XEk0z8HlV6FfqxIMI_KqC2Bg4NNp7EnjVqQ-gSS04t83nsvgLhBqJ8AI/s1600/image_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="258" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgR72L5bD_1Tx5gkfFybmExFfnuOGlc5u__7fW5VF6_tAybpUKD_uwhgIpuEd2gLUg23_8yUjG6bF8DMOPuxS_XEk0z8HlV6FfqxIMI_KqC2Bg4NNp7EnjVqQ-gSS04t83nsvgLhBqJ8AI/s320/image_1.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Uncheck “Use Approval Hierarchies”
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm_HGixka5ipva1s2TiLcwlgI7atUzczy4W9unb1DT5k4gm5j0ApIivzM4XnV2xN6nBZD6KaV6CPUC1x210Eh-6DcN08cwiwGMeivm2aAbBSQmVE5mRpXEZkDkGYzZmWPoQLwMrherpE4/s1600/image_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="198" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm_HGixka5ipva1s2TiLcwlgI7atUzczy4W9unb1DT5k4gm5j0ApIivzM4XnV2xN6nBZD6KaV6CPUC1x210Eh-6DcN08cwiwGMeivm2aAbBSQmVE5mRpXEZkDkGYzZmWPoQLwMrherpE4/s320/image_3.png" width="320" /></a></div>
<br />
<br />
Purchasing-> Setup-> Purchasing-> Document Types
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVgXWPII3EkiHLz1iXq0iVgSeWudzkUxiQQ3ZFrlM6Q1zURQFlWud3VTvnZcNgou4Hs8ir4RzcPxxFzD1aajiARDUrp6LOVeoSJxMbo72zYj_nQTLE1lLnYsmLG0CRvJQchpGQm4KSTZE/s1600/image_5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="255" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVgXWPII3EkiHLz1iXq0iVgSeWudzkUxiQQ3ZFrlM6Q1zURQFlWud3VTvnZcNgou4Hs8ir4RzcPxxFzD1aajiARDUrp6LOVeoSJxMbo72zYj_nQTLE1lLnYsmLG0CRvJQchpGQm4KSTZE/s320/image_5.png" width="320" /></a></div>
<br />
<br />
Click the update icon for specific document as in our case “Standard Purchase Order”
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgm37FeoxibNOE0gjn0azt8zdVW1BnuVbnUvNcCMHJQCN7QiHCCO8VxJpyGVQBt46yUrFZ27GNHuQWgUBTEOFlw61h_FpVuakOp5s3TnM85KHbyIH0bcggQ-YeRUI6ZUPr934PaJgJj4xU/s1600/image_7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="232" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgm37FeoxibNOE0gjn0azt8zdVW1BnuVbnUvNcCMHJQCN7QiHCCO8VxJpyGVQBt46yUrFZ27GNHuQWgUBTEOFlw61h_FpVuakOp5s3TnM85KHbyIH0bcggQ-YeRUI6ZUPr934PaJgJj4xU/s320/image_7.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
“Owner Can Approve” should be Unchecked.
<br />
“Default Hierarchy” should be left blank.
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5wURnXCXq4UNMRm2ct2dJ54VoxsOBK5PshRisTaiCKjKP5Qk1NIM8Dumw1XO2QXLozSCH7fNbPcfFZPU_doKhx9_6h5XVkkg6qCL49Ae-ZWap2M8aEiX4EkRiKEiP6W0y9huj9JyY9Z0/s1600/image_9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5wURnXCXq4UNMRm2ct2dJ54VoxsOBK5PshRisTaiCKjKP5Qk1NIM8Dumw1XO2QXLozSCH7fNbPcfFZPU_doKhx9_6h5XVkkg6qCL49Ae-ZWap2M8aEiX4EkRiKEiP6W0y9huj9JyY9Z0/s320/image_9.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
HRMS Manager-> People-> Enter and Maintain-> Find->Assignments
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1XByIfT0DAwejOAv-IVvPwAqoToe4Kj48cenzUvZl7rX_ifK8d_FNnmgqTsu6iR13U7SN8GWGXmUtcOmKn6_fT1JjUO8cBks2diNV_C8PkyWDDJgDVwzahRXVMW2FGpxP9ZmxDDY599s/s1600/image_11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="306" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1XByIfT0DAwejOAv-IVvPwAqoToe4Kj48cenzUvZl7rX_ifK8d_FNnmgqTsu6iR13U7SN8GWGXmUtcOmKn6_fT1JjUO8cBks2diNV_C8PkyWDDJgDVwzahRXVMW2FGpxP9ZmxDDY599s/s320/image_11.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Select Supervisor Tab and select Supervisor
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzTFjF4CLwtlGPX9kPnUGcOrQ8S_sT6Qm6zmw_EZj64cwnKkkIjjTRLFq6CcLxfhSxQ5d6SyRgOwJAm9v6scrlKRkrJd1mJlpAfPDIMwBU-xvQWROSjMhNu3t1dQ5pll3CfltZqGb9grI/s1600/image_13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzTFjF4CLwtlGPX9kPnUGcOrQ8S_sT6Qm6zmw_EZj64cwnKkkIjjTRLFq6CcLxfhSxQ5d6SyRgOwJAm9v6scrlKRkrJd1mJlpAfPDIMwBU-xvQWROSjMhNu3t1dQ5pll3CfltZqGb9grI/s320/image_13.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Purchasing-> View-> Request-> ”Fill Employee Hierarchy”
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIV59EnK5N-HW9tFqhHG8G5TzC-TxjmkSQrgS_-P7pK3rR9VFwuJZpHHuX3ROyYFmxJb9yIAf9UPuNHBhZOdzVXiX9sGXK3l0Zt-dfZUg5ntAnv1AzyrQQbUdjuAE43IowAV3_Os0mu4w/s1600/image_15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="219" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIV59EnK5N-HW9tFqhHG8G5TzC-TxjmkSQrgS_-P7pK3rR9VFwuJZpHHuX3ROyYFmxJb9yIAf9UPuNHBhZOdzVXiX9sGXK3l0Zt-dfZUg5ntAnv1AzyrQQbUdjuAE43IowAV3_Os0mu4w/s320/image_15.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<br />
<br />
<span itemprop="reviewRating" itemscope="" itemtype="http://schema.org/Rating">
<img alt="3 Stars" class="stars" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfivJCFwgW4kSM759bW3ycjVZKm2Da2u2olN8MMYQIQ96H825dD-lrF0BqavM2Wrs8duiWdcBRIbX7TUIYNOxajsHnv5YEDB_AaaJLAm-dbnPsuCEDr9h_fd_HcU3SLmeZ4_eHsnpccwk/s1600/three-stars.png" />
</span>
<strong>
</strong><div class="hreview"> <span class="item"> <span class="fn">Oracle Apps : Steps to Implement Employee/Supervisor Approval Hierarchy</span><br/> </span> Reviewed by <span class="reviewer">Anurag Jain</span>on <span class="dtreviewed">Jul 07 1995<span title="2015-06-24" class="value-title"></span><br/> </span> Rating: <span class="rating">Your-Rating</span></div>
<strong>
</strong>Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-40295484183352737672015-06-22T12:29:00.001+05:302015-06-22T13:02:40.706+05:30Oracle Apps : Steps to implement Position Hierarchies<h3>
Create a User</h3>
System Administrator -> Security -> User
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg40e8nR2kMMVZr6WdBeUPp02RsCNwGHOdTcAeURyfvQ8aRWVPbGU0bXlUs7iv4ODtdPu_RM00FyjlawSS3BjmC3e_rb2U0BItAI8I7XqYLR-oqPEgSFrdlEaSmr3fmxEngTN01vV0avOQ/s1600/image_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="257" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg40e8nR2kMMVZr6WdBeUPp02RsCNwGHOdTcAeURyfvQ8aRWVPbGU0bXlUs7iv4ODtdPu_RM00FyjlawSS3BjmC3e_rb2U0BItAI8I7XqYLR-oqPEgSFrdlEaSmr3fmxEngTN01vV0avOQ/s320/image_1.png" width="320" /></a></div>
<h3>
Assign Purchasing and HRMS Responsibility</h3>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-VPIG0Nv0EhEQlakjQBjZir47I5Z3Y28LyxOrKBcOSrTIopxBIhwlayBx6xqP_ar4vSrHYKIE5QPGybnHI4LHmqon2JUne1qoyJaDI4DvVGnIq9IXdAk9vGAAOX8BvbZCDDDMAuKG0Dg/s1600/image_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-VPIG0Nv0EhEQlakjQBjZir47I5Z3Y28LyxOrKBcOSrTIopxBIhwlayBx6xqP_ar4vSrHYKIE5QPGybnHI4LHmqon2JUne1qoyJaDI4DvVGnIq9IXdAk9vGAAOX8BvbZCDDDMAuKG0Dg/s320/image_3.png" width="320" /></a></div>
<h3>
Create Employee</h3>
<div class="separator" style="clear: both; text-align: center;">
</div>
HRMS Manager-> People-> Enter and Maintain ->New<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSP8cwKkQs7xUUCsLEF7irLtntV5XBztyH5To2AIgGFBbC6QKd-MzhEoPKzbPBAgEnCZPkFRqeK5WtdcsKSxLWEd_-GO3jy8rkpn00d6dvkW38YcmSGW_HCq92UdOg3rd5gRG1hoswCbw/s1600/image_5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="256" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSP8cwKkQs7xUUCsLEF7irLtntV5XBztyH5To2AIgGFBbC6QKd-MzhEoPKzbPBAgEnCZPkFRqeK5WtdcsKSxLWEd_-GO3jy8rkpn00d6dvkW38YcmSGW_HCq92UdOg3rd5gRG1hoswCbw/s320/image_5.png" width="320" /></a></div>
<br />
<h3>
Click Assignment Button to Assign Job and Position
</h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnG3Rfeg5nYxPg6fAvPP1NNGkJ4oITmNbcg9VHPJmCtVVMmJ_uy30F_TS3mCmC4q7Dc763SdFCRRSloX6_FfrXYuo2QQ_-vSa39U6RUVQ4giTmpRMFEFGg9KX0Z4igHa1Pd-k8UiHwMOY/s1600/image_7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="214" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnG3Rfeg5nYxPg6fAvPP1NNGkJ4oITmNbcg9VHPJmCtVVMmJ_uy30F_TS3mCmC4q7Dc763SdFCRRSloX6_FfrXYuo2QQ_-vSa39U6RUVQ4giTmpRMFEFGg9KX0Z4igHa1Pd-k8UiHwMOY/s320/image_7.png" width="320" /></a></div>
<h3>
Assign Job and Position
</h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjne3TgzNwIn1rzuTPri1FlDpHW4LNXPB_CT5lIkvkH0372TMVFT_0L7wt69czRuw-_F-y37i2RPwzfU6dnnGcjjxbrsKNpxghtmREy-voftoWdo9KyiTQxTelP9TDbwlKg6IJ5Yp5KikI/s1600/image_9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjne3TgzNwIn1rzuTPri1FlDpHW4LNXPB_CT5lIkvkH0372TMVFT_0L7wt69czRuw-_F-y37i2RPwzfU6dnnGcjjxbrsKNpxghtmREy-voftoWdo9KyiTQxTelP9TDbwlKg6IJ5Yp5KikI/s320/image_9.png" width="320" /></a></div>
<h3>
Assign Employee to User</h3>
Go to System Administrator -> Security - > User<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8HHboUsQdSatgXMXyAh6Iamh4tNUC5xLlEwy3s9nVrjCPjeJsQREDhzbiksW1qmokhchR4_KYCDBN-mo-hcBQTnqjUvLVF2YXOK6i8OQ_DJ8tmSue0kPkxQBWH5jpKlU10yDfhAv8UHo/s1600/image_11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8HHboUsQdSatgXMXyAh6Iamh4tNUC5xLlEwy3s9nVrjCPjeJsQREDhzbiksW1qmokhchR4_KYCDBN-mo-hcBQTnqjUvLVF2YXOK6i8OQ_DJ8tmSue0kPkxQBWH5jpKlU10yDfhAv8UHo/s320/image_11.png" width="320" /></a></div>
<br />
If Employee is not a buyer, We will get a pop-up as below
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg93t2nZD8-mb1SkHZBvlvMUHUvU0KlBNaSNy9y8yM5KSO4T1jLIlblt-jRHtC8l6R8et2Dp2MV3JDQBEs7ny4Ylq4U6ShM7svolnsE5Aky8ty_PJRwKH72_b0OagKu8hyphenhyphenNU_m1HbQ333A/s1600/image_13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="159" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg93t2nZD8-mb1SkHZBvlvMUHUvU0KlBNaSNy9y8yM5KSO4T1jLIlblt-jRHtC8l6R8et2Dp2MV3JDQBEs7ny4Ylq4U6ShM7svolnsE5Aky8ty_PJRwKH72_b0OagKu8hyphenhyphenNU_m1HbQ333A/s320/image_13.png" width="320" /></a></div>
<h4>
Press “Add Buyer” Button to make an employee a buyer</h4>
Go to Purchasing->Setup->Personnel-> Buyer<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQwJa4ayqFwKgQpOgR4t-lkje-pQpk5PhHL_YyIZboyQV64Heck8SBYmWVCFf59rkdu8EbPSNvRV6SSfYWh1Qpw4EetL4ANjGU0U467uh-ThfPqJDWomyTWG8T5JgsoqIiMrJ4_g_74aw/s1600/image_15.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="255" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQwJa4ayqFwKgQpOgR4t-lkje-pQpk5PhHL_YyIZboyQV64Heck8SBYmWVCFf59rkdu8EbPSNvRV6SSfYWh1Qpw4EetL4ANjGU0U467uh-ThfPqJDWomyTWG8T5JgsoqIiMrJ4_g_74aw/s320/image_15.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn3XfSMuTGF3SbPgj9yARRI4VNqP1yc0MItqla8QQDFJrQYn1eLm4AgyJRyHWgGVQ_amZlR2u4kGBTd5ENpKoPSFJRW2kFudmjGNfDuWgZV2nZBvfVtWS66lw4ZHlxxMR9ga6RRicB4TM/s1600/image_16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="25" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn3XfSMuTGF3SbPgj9yARRI4VNqP1yc0MItqla8QQDFJrQYn1eLm4AgyJRyHWgGVQ_amZlR2u4kGBTd5ENpKoPSFJRW2kFudmjGNfDuWgZV2nZBvfVtWS66lw4ZHlxxMR9ga6RRicB4TM/s320/image_16.png" width="320" /></a></div>
<h4>
To remove an employee as buyer Query the employee name and End Date it</h4>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEip6qS6SjY1wqtR5nzPRWQJpl9OFpVtY4nfhA2ufzP4l3FST39X1FEAQeWjuHmcGW0AV5n9Dzvivf6euflM-QMG28hvahsbPYhkOurE6yXpr4N5-1VESiKo8lfVPh-METvyhOkfBAL25jc/s1600/image_18.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="129" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEip6qS6SjY1wqtR5nzPRWQJpl9OFpVtY4nfhA2ufzP4l3FST39X1FEAQeWjuHmcGW0AV5n9Dzvivf6euflM-QMG28hvahsbPYhkOurE6yXpr4N5-1VESiKo8lfVPh-METvyhOkfBAL25jc/s320/image_18.png" width="320" /></a></div>
<div>
<br /></div>
Now Create a Purchase Order Purchasing- > Purchase Orders -> Purchase Orders
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfVmzAi77zcLxqJPKJTureI51l2p2tPZtWSSxOjVmOdHNlf-nGxsLL1BPKYK_C4mfe_DwHk1snD6zlAGK157qpdOIs1Y3KpdaVqyxuhJiSdnWcZ1kFWWreVCRrHVKUZT8c3jxRSfUJCLk/s1600/image_20.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfVmzAi77zcLxqJPKJTureI51l2p2tPZtWSSxOjVmOdHNlf-nGxsLL1BPKYK_C4mfe_DwHk1snD6zlAGK157qpdOIs1Y3KpdaVqyxuhJiSdnWcZ1kFWWreVCRrHVKUZT8c3jxRSfUJCLk/s320/image_20.png" width="320" /></a></div>
Enter the PO Details</h3>
Assigned User’s employee will be defaulted as Buyer <br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<h4>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2lqpzrcVLUHA8Q2ilLajf6v3BAQsJbOEeWb4yeRArzM0WgKjBWttNovTjqxDpFrSe_z24sNV1y77ftgg1LG3bSnafsMj5p0fu1NdIyp6UdFlZkIpstyUxnvFXC-OrF18JxO1O3gT4c-g/s1600/image_22.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2lqpzrcVLUHA8Q2ilLajf6v3BAQsJbOEeWb4yeRArzM0WgKjBWttNovTjqxDpFrSe_z24sNV1y77ftgg1LG3bSnafsMj5p0fu1NdIyp6UdFlZkIpstyUxnvFXC-OrF18JxO1O3gT4c-g/s320/image_22.png" width="320" /></a></div>
Press “Approve” Button to approve the PO</h4>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpa80c7Bbs_g1fWX1rmI9TobDkzbnlcNVvlBHAxtFJbMjf09F9QePTFMqFYcoEaWSVn35wxg-HAf0fvJpnqWVD4Yjtp9U1Dt_f7MpgiGXKiFszvIt9xo_qlJKgJo4CRraprmveOga7NdE/s1600/image_24.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpa80c7Bbs_g1fWX1rmI9TobDkzbnlcNVvlBHAxtFJbMjf09F9QePTFMqFYcoEaWSVn35wxg-HAf0fvJpnqWVD4Yjtp9U1Dt_f7MpgiGXKiFszvIt9xo_qlJKgJo4CRraprmveOga7NdE/s320/image_24.png" width="320" /></a></div>
<div>
<br /></div>
<h2>
Document Types in Purchasing
</h2>
Purchasing-> Setup-> Purchasing-> Document Types
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFO4RJddEI0qQLrHJQlM_yDciGijAFPm8o9tYHRQtP96IsaOQNy_0kMSXa-zMpPMvEQApYsFWjqpCaj30nAxV4Coj05Zp7wBfVhJP1np1uDjyp7RTOCC1fSDBgpgnDgSNi927WKOr01Uw/s1600/image_26.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFO4RJddEI0qQLrHJQlM_yDciGijAFPm8o9tYHRQtP96IsaOQNy_0kMSXa-zMpPMvEQApYsFWjqpCaj30nAxV4Coj05Zp7wBfVhJP1np1uDjyp7RTOCC1fSDBgpgnDgSNi927WKOr01Uw/s320/image_26.png" width="320" /></a></div>
<br />
“Owner Can Approve” Option if checked and employee is assigned to a Approval Group which has no limits to approve the PO created then created PO will get approved.
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1qye8dhstLheakHNv4w4WpKzVVPTqw__oKvzcCHsdZ4ORxBRDDoVFgTRz4C3VdoOeHPH_a_g7JwCElJ5GBHW_thkVAhDZX8UFxSjfNXvPAYycnMM6G0zQlWkp7V3qNEn9FghUDgmsE7s/s1600/image_28.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="72" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1qye8dhstLheakHNv4w4WpKzVVPTqw__oKvzcCHsdZ4ORxBRDDoVFgTRz4C3VdoOeHPH_a_g7JwCElJ5GBHW_thkVAhDZX8UFxSjfNXvPAYycnMM6G0zQlWkp7V3qNEn9FghUDgmsE7s/s320/image_28.png" width="320" /></a></div>
<br />
<h2>
Setup Steps
</h2>
<div>
<br /></div>
Uncheck the “Owner Can Approve” box in Document Types under Standard Purchase Order
<br />
Purchasing-> Setup-> Purchasing -> Document Types
<br />
<br />
Assign the Default Hierarchy that needs to be followed in Document Types under Standard Purchase Order
<br />
Purchasing-> Setup-> Purchasing-> Document Types
<br />
<br />
Go to Financial Option and check “Use Approval Hierarchy”
<br />
Purchasing-> Setup-> Organization-> Financial Options
<br />
<br />
Position Hierarchy in HRMS Manager should have a correct assignments as required.
<br />
HRMS Manager ->Work Structures ->Position ->Hierarchy
<br />
<br />
Superiors approval Limit should be good enough to approve the Purchase Order created.
<br />
<h2>
Defining Position Hierarchy
</h2>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijbctipQGPzS9JBhjusyaos-mRdRzO9KS_ayst9vsr-PGuIBuZMdOpKPVdQ9tcOYB0wG0EK98Dk_JWS-ONLt9D5aj9Xjejxb1VYl7nGH2pfEe6LKmtmqLMUsFA-cPyCRMhHFqWdh_Br98/s1600/image_31.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijbctipQGPzS9JBhjusyaos-mRdRzO9KS_ayst9vsr-PGuIBuZMdOpKPVdQ9tcOYB0wG0EK98Dk_JWS-ONLt9D5aj9Xjejxb1VYl7nGH2pfEe6LKmtmqLMUsFA-cPyCRMhHFqWdh_Br98/s320/image_31.png" width="320" /></a></div>
<br />
<div>
<br /></div>
<br />
<ul>
<li>Purchasing-> Setup-> Purchasing->Document Types</li>
<li> “Owner Can Approve” Option Uncheck “Default Hierarchy” should be assigned</li>
<li> “Forward Method” if it should directly go to the next level employee who has the authority to approve the select “Direct” else select “Hierarchy”</li>
</ul>
<br />
Purchasing-> Setup-> Organization-> Financial Options<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimoU5FoM_Vy6-fVFz-920ZQ3PlO06EV9r6GIDDdfB_aoj4vWbfTxt56V2mPcvx-ctym2qCZhVkoxe9no2U6eVwSTB85l9Eh-BSdUcmtdgGlZBWx83BOEZrkeMdh7tzMRXZLOgRlcfNloY/s1600/image_33.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="257" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimoU5FoM_Vy6-fVFz-920ZQ3PlO06EV9r6GIDDdfB_aoj4vWbfTxt56V2mPcvx-ctym2qCZhVkoxe9no2U6eVwSTB85l9Eh-BSdUcmtdgGlZBWx83BOEZrkeMdh7tzMRXZLOgRlcfNloY/s320/image_33.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
“Use Approval Hierarchy” box should be checked<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyPaNlYHL4iLFr8yDX2jjI9l5IyVLsm1JvgrQm1pUg_wz_gbOv8MD-dxqlnKZzYbVlYXoPmzWTxAJLF_-ur_H0I5gq6YJnMVWhvMCyI5BUiH7BsJIwqqcVPazYz-rQawNad8sKTnFsA6w/s1600/image_35.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="196" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhyPaNlYHL4iLFr8yDX2jjI9l5IyVLsm1JvgrQm1pUg_wz_gbOv8MD-dxqlnKZzYbVlYXoPmzWTxAJLF_-ur_H0I5gq6YJnMVWhvMCyI5BUiH7BsJIwqqcVPazYz-rQawNad8sKTnFsA6w/s320/image_35.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-7660982083176054942015-06-09T14:16:00.001+05:302015-06-09T14:16:18.362+05:30Oracle Apps : Apply AP Invoice Hold using APIThe hold codes can be extracted from query below.<br />
<br />
SELECT *<br />
FROM ap_hold_codes<br />
WHERE hold_type = 'INVOICE HOLD REASON';<br />
<br />
Below is the API to apply hold using Standard Oracle API :<br />
<br />
<br />
PROCEDURE inv_hold (p_invoice_id IN NUMBER,<br />
p_reject_code IN VARCHAR2,<br />
p_hold_val_status IN VARCHAR2,<br />
x_status OUT VARCHAR2)<br />
IS<br />
l_hold_invoice_id NUMBER := NULL;<br />
l_hold_err_msg VARCHAR2 (2000) := NULL;<br />
BEGIN<br />
l_hold_invoice_id := p_invoice_id;<br />
<br />
IF l_hold_invoice_id IS NOT NULL<br />
AND p_reject_code IS NOT NULL<br />
AND p_hold_val_status = 'Y'<br />
THEN<br />
BEGIN<br />
ap_holds_pkg.insert_single_hold (<br />
X_invoice_id =&gt; l_hold_invoice_id,<br />
X_hold_lookup_code =&gt; p_reject_code);<br />
<br />
x_status := 'S';<br />
EXCEPTION<br />
WHEN OTHERS<br />
THEN<br />
l_hold_err_msg :=<br />
'Unknow Exception Occured in Hold API call.. Exception Code : '<br />
|| SQLCODE<br />
|| ' Exception Details : '<br />
|| SQLERRM;<br />
DBMS_OUTPUT.put_line (l_hold_err_msg);<br />
END;<br />
END IF;<br />
EXCEPTION<br />
WHEN OTHERS<br />
THEN<br />
DBMS_OUTPUT.put_line (SQLERRM);<br />
END inv_hold;<br />
<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-22006871605097645902015-06-04T18:32:00.003+05:302015-06-22T14:22:43.066+05:30Query to Find Attached Template Name from Template Code<br />
SELECT template_code, file_name<br />
FROM xdo_templates_b a, xdo_lobs b<br />
WHERE b.lob_code = a.template_code<br />
AND b.xdo_file_type = 'RTF'<br />
AND a.template_code = 'XXXBITEMPLATE';<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-69236589247821894802015-05-26T17:22:00.003+05:302015-05-26T17:22:19.598+05:30Query to drill down from PO header to shipment<br />
<br />
SELECT poll.*<br />
FROM po_headers_all poh,<br />
po_releases_all pora,<br />
po_lines_all pla,<br />
po_line_locations_all poll<br />
WHERE poh.po_header_id = pora.po_header_id<br />
AND pla.po_line_id = poll.po_line_id<br />
AND poll.po_release_id = pora.po_release_id<br />
AND poh.segment1 = :po_number<br />
AND pora.release_num = :po_release_num<br />
AND pla.line_num = :po_line_num<br />
AND poh.org_id = :org_id;<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-2995751898561232602015-05-21T12:26:00.002+05:302015-05-21T12:26:51.937+05:30How To Disable/End Date/ Delete Responsibilities of a User from Backend/API<br />
Below is the query. <br />
Please not Responsibilities cannot be deleted in Oracle Apps from a User. It can only be Disabled or End Dated.<br />
<br />
<br />
BEGIN<br /> FOR I<br /> IN (SELECT fu.user_id,<br /> fu.user_name,<br /> furg.RESPONSIBILITY_APPLICATION_ID,<br /> frv.RESPONSIBILITY_NAME,<br /> frv.RESPONSIBILITY_KEY,<br /> fa.application_short_name,<br /> frg.security_group_key<br /> FROM FND_USER fu,<br /> FND_USER_RESP_GROUPS furg,<br /> FND_RESPONSIBILITY_VL frv,<br /> fnd_application fa,<br /> fnd_security_groups frg<br /> WHERE fu.user_id = furg.user_id<br /> AND furg.responsibility_id = frv.responsibility_id<br /> AND frv.application_id = fa.application_id<br /> AND frv.data_group_id = frg.security_group_id<br /> AND fu.user_name = 'ABC'<br /> AND frv.RESPONSIBILITY_NAME IN ('Receivables Support'))<br /> LOOP<br /> BEGIN<br /> DBMS_OUTPUT.put_line (<br /> i.user_name<br /> || i.application_short_name<br /> || i.responsibility_key<br /> || i.security_group_key);<br /> fnd_user_pkg.delresp (username => i.user_name,<br /> resp_app => i.application_short_name,<br /> resp_key => i.responsibility_key,<br /> security_group => i.security_group_key);<br /> DBMS_OUTPUT.put_line (<br /> i.RESPONSIBILITY_NAME || ' End Dated Successfully ');<br /> COMMIT;<br /> EXCEPTION<br /> WHEN OTHERS<br /> THEN<br /> DBMS_OUTPUT.put_line (SQLERRM);<br /> END;<br /> END LOOP;<br />EXCEPTION<br /> WHEN OTHERS<br /> THEN<br /> DBMS_OUTPUT.put_line (<br /> 'Error encountered while deleting responsibilty from the user and the error is '<br /> || SQLERRM);<br />END;<br />/<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-46006628227445711172015-05-19T12:59:00.001+05:302015-05-19T12:59:57.717+05:30Query to Find Database Version in Oracle<br />
<br />
select * from v$version;<br />
<br />
<b>Output:</b><br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihwpS93UZv_j8WgxqBn-dPBfgF7H3jiZDFEzGF_MO-CH2WedGKM5MDrPjn_7zxqqx9jwLxNdLHILOBcLq1vIBXnAb4Q9pMejDq2MkUNVYHq5p6wp4Pz6fTUn2RUZIQFugHvdJjyd6Bc90/s1600/Database+Version.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="172" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihwpS93UZv_j8WgxqBn-dPBfgF7H3jiZDFEzGF_MO-CH2WedGKM5MDrPjn_7zxqqx9jwLxNdLHILOBcLq1vIBXnAb4Q9pMejDq2MkUNVYHq5p6wp4Pz6fTUn2RUZIQFugHvdJjyd6Bc90/s400/Database+Version.png" width="400" /></a></div>
<div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-61138271728465288092015-05-13T10:33:00.001+05:302015-05-13T10:33:09.667+05:30FND DEBUG / FND LOG MESSAGES<h3>
What is FND Debug Log ?</h3>
<br />
<ol>
<li>It helps you pinpoint the cause of error in standard Oracle Code, by making debug messages to appear in a centralized table named <b>FND_LOG_MESSAGES</b>. </li>
<li>You can design and build your custom extensions in a manner that can easily be debugged. This can be done by calling Oracle delivered API’s in your custom code. </li>
</ol>
<br />
A program written in any technology, either form, report, PL/SQL, java concurrent program, OAF has their debug message stored in FND_LOG_MESSAGES.<br />
<h3>
How does this work? </h3>
How to use FND debug Log to pinpoint the error?<br />
<br />
<b>Step 1:</b>
Set up profiles for the User / Responsibility to be used to reproduce the issue<br />
<br />
FND: Debug Log Enabled -> YES This turns the debugging feature on<br />
FND: Debug Log Filename -> NULL Use when you want debug messages to get stored to a file
FND: Debug Log Level -> STATEMENT<br />
FND: Debug log module -> %<br />
If the error pertains to a specific module use the application short name.<br />
Ex: For receivable use FND: Debug log module -> ar%<br />
<br />
Log into the Oracle application<br />
<br />
<b>Step 2:</b>
Since the debugging routine will start writing messages to the table, we want to know which messages pertain to our test. If you are tracking the debug messages for a concurrent request, note down the Concurrent Request id. Otherwise, note down current max value of log sequence retrieved as follows :<br />
<br />
<b><i>SELECT MAX(LOG_SEQUENCE) FROM FND_LOG_MESSAGE </i></b><br />
<br />
<b>Step 3:</b>
Run the test case, avoiding extraneous steps to avoid stacking the table.<br />
<br />
<b>Step 4:</b><br />
<br />
a) For a concurrent process:<br />
<br />
<b><i> SELECT LOG.module, LOG.MESSAGE_TEXT MESSAGE</i></b><br />
<b><i> FROM fnd_log_messages LOG, fnd_log_transaction_context con</i></b><br />
<b><i> WHERE request_id = <Conc Req ID></i></b><br />
<b><i> AND con.transaction_type = 'REQUEST'</i></b><br />
<b><i> AND con.transaction_context_id = LOG.transaction_context_id</i></b><br />
<b><i>ORDER BY LOG.log_sequence;</i></b><br />
<br />
<br />
b) For any other debugging:<br />
<br />
<b><i>SELECT module, MESSAGE_TEXT</i></b><br />
<b><i> FROM fnd_log_messages</i></b><br />
<b><i> WHERE log_sequence = (SELECT MAX (LOG_SEQUENCE) FROM FND_LOG_MESSAGE);</i></b><br />
<br />
<br />
Obtaining the log messages via Oracle Application:<br />
<br />
1) Query Profile: %FND%DEBUG%<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfZO0aCJwjaHzZiPswMrfO7RpineanIzyRQqqQYdenBnhvzoXuNvu3-JhnTdECs3pDL5sd8HsWVMdwoU4g3U1XawKQA4M98M43yJ5XXUPJlANsoEomDUVZCiqfdYKrawY67FUz42Ocras/s1600/Find+System+Profile+Values.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="251" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfZO0aCJwjaHzZiPswMrfO7RpineanIzyRQqqQYdenBnhvzoXuNvu3-JhnTdECs3pDL5sd8HsWVMdwoU4g3U1XawKQA4M98M43yJ5XXUPJlANsoEomDUVZCiqfdYKrawY67FUz42Ocras/s400/Find+System+Profile+Values.png" width="400" /></a></div>
<br />
<br />
2) Set the FND: Debug Log Enabled: Yes<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhL3iPzvMEvZCtUdcAUPU4-bNP1RDubi2MzsOI4i-wPF5GaYxDYAfDGoaW-R4wA-9XVr5UTAG7wvxywtNvNWnWEi-sXagRbu1TOELtE6319em4d2LRrKaLjOXx_lnIWIgZKuRZtoAO55e4/s1600/Find+System+Profile+Values.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="251" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhL3iPzvMEvZCtUdcAUPU4-bNP1RDubi2MzsOI4i-wPF5GaYxDYAfDGoaW-R4wA-9XVr5UTAG7wvxywtNvNWnWEi-sXagRbu1TOELtE6319em4d2LRrKaLjOXx_lnIWIgZKuRZtoAO55e4/s400/Find+System+Profile+Values.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
3) System Administrator > Help > Debug Logging > View<br /><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWphQCK4Dqvt8mOh_gNjIeDyQBbzqnZXJw2ff8BkoVQCb-xAt88B30zlsvuVLHA11E7yen7vuJ9S0d_OUNmPw2kIsoOx7VrImwH55xUF0av1Bg3ladQIHYxjPP3-eEhmz42VtKRv2IY44/s1600/Debug+Logging+Dashboard.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWphQCK4Dqvt8mOh_gNjIeDyQBbzqnZXJw2ff8BkoVQCb-xAt88B30zlsvuVLHA11E7yen7vuJ9S0d_OUNmPw2kIsoOx7VrImwH55xUF0av1Bg3ladQIHYxjPP3-eEhmz42VtKRv2IY44/s400/Debug+Logging+Dashboard.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
4) set the values and run any concurrent program<br />
5) Then navigate to the above screen and download the complete fnd log messages report by exporting as a CSV.<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-76262928251943055952015-04-28T16:35:00.000+05:302015-04-28T16:35:15.166+05:30Debug : javax.servlet.http.httpservletrequest cannot be resolvedYou can do either of the following to resolve this error.<br />
<br />
<br />
<ul>
<li>Right-click the project tab, click Properties.</li>
<li>Choose Build Path -> Java Build Path</li>
<li>Choose Add External JARs</li>
<li>Browse to find and select servlet-api.jar which should be present in ...<i>\apache-tomcat-7.0.61\lib\</i></li>
<li>Click OK to update the build path.</li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgI9y-q3f3LTQ9Mnf5TtFQiQVmcGsmwjkSI3vcyfLAQjO_tW081X9pgmKyYJuEhyphenhyphenqmJMqLOFVEFISbWpgg7FPFCskWw0w_T0hnp_3lnMuWqb1cu3YG-I1KVSZdy4KVePGfzxUtkqLAXMnY/s1600/servlet-api.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgI9y-q3f3LTQ9Mnf5TtFQiQVmcGsmwjkSI3vcyfLAQjO_tW081X9pgmKyYJuEhyphenhyphenqmJMqLOFVEFISbWpgg7FPFCskWw0w_T0hnp_3lnMuWqb1cu3YG-I1KVSZdy4KVePGfzxUtkqLAXMnY/s1600/servlet-api.png" height="210" width="400" /></a></div>
<br />
OR<br />
you can simply copy the servlet-api.jar present in <i>...\apache-tomcat-7.0.61\lib\ </i>and copy that jar files into lib folder, which is in WEB-INF. then just clean and built your project, your errors will be solved.<br />
<div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-45726760123938694712015-04-13T15:57:00.001+05:302015-04-13T15:57:26.988+05:30How to use plsql collections in select statment<b>Step 1 : Declare Collection type Globally</b><br /><i><br />For Example: </i><br /><br /> Test_Coll can be declared globally as "TYPE Test_Coll IS TABLE OF INTEGER"<br /><br /><b>Step 2 :</b><br /><br />DECLARE<br />
<br /> test_coll_tab Test_Coll;<br /> MyName VARCHAR2(100);<br />
<br />BEGIN<br />
<br />test_coll_tab = Test_Coll();<br />test_coll_tab.extend;<br />test_coll_tab(1):=1;<br />test_coll_tab.extend;<br />test_coll_tab(2):=2; <br />test_coll_tab.extend;<br />test_coll_tab(3):=3; <br />test_coll_tab.extend;<br />test_coll_tab(4):=4; <br />test_coll_tab.extend;<br />test_coll_tab(5):=5; <br /><br /> SELECT Name <br /> INTO MyName<br /> FROM Item<br /> WHERE ItemId NOT IN (select * from table(test_coll_tab));<br />
<br />END;<br />
<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-17212163532448268852015-04-03T16:05:00.001+05:302015-04-03T16:05:12.519+05:30How to send Concurrent Program output as an EmailThere are two Methods to send Concurrent Program Output as Email<br />
<h4>
Method 1:</h4>
<ul>
<li>The printer styles have to be configured to execute a shell script instead of sending the output to a physical printer. </li>
<li>The shell script then emails the concurrent program output to the intended recipient. </li>
</ul>
<h4>
Method 2: (Applicable R12.1.3 onwards)</h4>
With the R12.1.3 release, a hook to the BI Publisher Delivery Manager is available on the SRS window to send the output to IPP Printers, Email, Fax and FTP destinations.
<br />
<br />
<br />
<b>Steps for Method 1
</b><br />
<b>Step 1: </b>Define/Query Printer Type: Define a new Printer Type or Query for an existing one. Responsibility: System Administrator Navigation: Install->Printer->Types<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisGvHF24IZA5qisN8q8UN-w49_cXJvtVHQqtCi9-s31_KAS32i6Pkn1vbgQDRm9vhNaH-GKKsSXtiYmio2EcbItadyon4eyIgjUt3mSRNsrhY9IAuPfj-BUb8yJojekI9mNgA2KSiMGW8/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisGvHF24IZA5qisN8q8UN-w49_cXJvtVHQqtCi9-s31_KAS32i6Pkn1vbgQDRm9vhNaH-GKKsSXtiYmio2EcbItadyon4eyIgjUt3mSRNsrhY9IAuPfj-BUb8yJojekI9mNgA2KSiMGW8/s1600/1.jpg" height="208" width="320" /></a></div>
<br />
<b>Step 2:</b> Define Printer Style: Click on the ‘Style’ button in the Printer Types form (as seen in the previous screenshot). Create a new style and save it.
<br /><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjr2Or7MS4D3kcJe49lvdM5iX-jwy4V8PmQ42rRFOFJxQtnHeLOegFafcoFAOOfYfwxSktF2sCRo4vax6_Z381A53J2sbUGksThmQ94dSEFw97vPJzudGcgkCOV6O41RkiiiAddha3BY68/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjr2Or7MS4D3kcJe49lvdM5iX-jwy4V8PmQ42rRFOFJxQtnHeLOegFafcoFAOOfYfwxSktF2sCRo4vax6_Z381A53J2sbUGksThmQ94dSEFw97vPJzudGcgkCOV6O41RkiiiAddha3BY68/s1600/2.jpg" height="169" width="320" /></a></div>
<b>Step 3: </b>Define Printer Driver: Click on ‘ Driver’ button in the Printer Types form. Specify Driver method as command. Specify the following in the arguments section:
$XXCUST_TOP/bin/EMAIL.sh $PROFILES$.CONC_REQUEST_ID 30<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiml-mCGzfob1oTud6UH5i1E46qAPsKOJqu9LiwWhPAXzkzvR6mGIGRp-VLNIuwD6WdSl1zZCBCh8MmNEg2LaPAqX_ZB0ptDA7FYeLQMgYhQUjghR0sjdEbzwm348ZyPHnuG-hqizO_dBs/s1600/3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiml-mCGzfob1oTud6UH5i1E46qAPsKOJqu9LiwWhPAXzkzvR6mGIGRp-VLNIuwD6WdSl1zZCBCh8MmNEg2LaPAqX_ZB0ptDA7FYeLQMgYhQUjghR0sjdEbzwm348ZyPHnuG-hqizO_dBs/s1600/3.jpg" height="206" width="320" /></a></div>
<br />
<b>Step 4: </b>Mapping: Map the Printer Style and Printer Driver to the Printer Type.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWQUQPgBbDhFSJzF5nbNSBkL9lPR67K4KELhLUTmNqUsdfdUUOeB4-Q5YnckwCBbxRhKGzDQGHfl7IDxQRQV0uyAgLKXIcVRei9auHySf20WiBLGhcT84CW1NtTca7twbeBcI-ARsENmA/s1600/4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWQUQPgBbDhFSJzF5nbNSBkL9lPR67K4KELhLUTmNqUsdfdUUOeB4-Q5YnckwCBbxRhKGzDQGHfl7IDxQRQV0uyAgLKXIcVRei9auHySf20WiBLGhcT84CW1NtTca7twbeBcI-ARsENmA/s1600/4.jpg" height="210" width="320" /></a></div>
<br />
<b>Step 5: </b>Install the Printer and map the Printer Type : Create a new printer and map the Printer Type created in the previous step.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiq2rwVtMKBJmKN6SJeJRMUUnOrBeDOslQC8d4p4VE4kQMdw3MjJXhbqoqtGo3nLMFKsgnPTAczsdm_KTenTWHDNOFv8UrHVW86grpG1wynlDqSwFFBYBjFnbuJvnnQqIcN9nvs-liPtg8/s1600/5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiq2rwVtMKBJmKN6SJeJRMUUnOrBeDOslQC8d4p4VE4kQMdw3MjJXhbqoqtGo3nLMFKsgnPTAczsdm_KTenTWHDNOFv8UrHVW86grpG1wynlDqSwFFBYBjFnbuJvnnQqIcN9nvs-liPtg8/s1600/5.jpg" height="223" width="320" /></a></div>
<br />
<b>Step 6: </b>Attach the defined printer to the concurrent program: Navigation: Concurrent > Program > Define .Specify printer in Output section<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFzG26UDQlCzKpV9ekKhp8j3_mdE8o-pilUHaafMYRm6xM_rVEc_xt8ylbyUiPryvqqdyWjkEd4j0hSGH-D0Fn1LBI17fYuZ7hlaSrtaDkYN9HOGVqaruLhxTgf_ZxCV9QFMdnjim_ijk/s1600/6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFzG26UDQlCzKpV9ekKhp8j3_mdE8o-pilUHaafMYRm6xM_rVEc_xt8ylbyUiPryvqqdyWjkEd4j0hSGH-D0Fn1LBI17fYuZ7hlaSrtaDkYN9HOGVqaruLhxTgf_ZxCV9QFMdnjim_ijk/s1600/6.jpg" height="214" width="320" /></a></div>
<br />
<b>Step 7: </b>Running the Concurrent Program: Before clicking on the Submit button in the SRS window, specify non-zero value of no. of copies by clicking on the Options button.
<br />
This will invoke Printer.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBFcX_Clswej_U70MYKhKtdx2_wydugxvl7KAHFgw8g9A3iUfdB0T7ooMs0Z0gPo-LZQpm1LoYq0GhIE5f5kLNtqTmAkTMbHrH_wNtUNKmNkwZHHlPrZfdfFJYnW7cCg-AGX5EnZw97LQ/s1600/7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBFcX_Clswej_U70MYKhKtdx2_wydugxvl7KAHFgw8g9A3iUfdB0T7ooMs0Z0gPo-LZQpm1LoYq0GhIE5f5kLNtqTmAkTMbHrH_wNtUNKmNkwZHHlPrZfdfFJYnW7cCg-AGX5EnZw97LQ/s1600/7.jpg" height="223" width="320" /></a></div>
<br />
<b>Step 8: </b>The sample shell script (email_conc_prog_output.sh) that is executed after the completion of the above steps is attached with the article.
<br />
<br />
<br />
<b>Steps for Method 2</b><br />
<br />
This feature is available in the new button ‘Delivery Opts’ as seen in the screenshot below.
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIS0hg6GBZUGK7SpQEFa5SqdtGdEasf98TVz18Zk-PBq1N1-RB0RKJV6qjBdCkAlPIs8h-QPmsndlKSxzeN3yjqVD9XwV7kjkZaQfHTi-rsdewB_GsbgHFB13cuEE8fJBXBAIOwOr_xwA/s1600/R12_1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIS0hg6GBZUGK7SpQEFa5SqdtGdEasf98TVz18Zk-PBq1N1-RB0RKJV6qjBdCkAlPIs8h-QPmsndlKSxzeN3yjqVD9XwV7kjkZaQfHTi-rsdewB_GsbgHFB13cuEE8fJBXBAIOwOr_xwA/s1600/R12_1.jpg" height="204" width="320" /></a></div>
On clicking the ‘Delivery Opts’ Button, a new form will pop up which will allow users to specific email addresses of the sender, recipient and carbon copy recipient (multiple emails can be specified separated by commas), subject of the email. This can be seen in the screenshot below.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLtgirQCVdiY62luD2VAIxfSm-mb5OcdPoCNm1DZFkmYh06ZlOueJScLBFVVAPb_2zqcgCRSI4R4ww1uOJr8RfbELNwJ95BX_bgQ_VROYknICQ7jq_AiryLIXIRocc8ziel9Xe5QQ79fU/s1600/R12_2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLtgirQCVdiY62luD2VAIxfSm-mb5OcdPoCNm1DZFkmYh06ZlOueJScLBFVVAPb_2zqcgCRSI4R4ww1uOJr8RfbELNwJ95BX_bgQ_VROYknICQ7jq_AiryLIXIRocc8ziel9Xe5QQ79fU/s1600/R12_2.jpg" height="180" width="320" /></a></div>
The Email tab (as seen in the screenshot above) utilizes SMTP to communicate to a mail host which in turn sends the email to the recipients. The hostname and port of the mail host is configured via the profile values:
<br />
FND: SMTP Host and FND: SMTP Port<br />
<br />
<br />
Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com1tag:blogger.com,1999:blog-7580318270837714276.post-46601292871907761882015-03-27T16:10:00.002+05:302015-03-27T16:10:37.161+05:30Oracle Apps R12 Query to Find Payment against Invoice<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><br />
<!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="371">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman",serif;}
</style>
<![endif]-->
<br />
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">SELECT</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> b</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">segment1 vendor_number</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
b</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">vendor_name
vendor_name</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
c</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">vendor_site_code</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
c</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">pay_group_lookup_code</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_num
invoice_number</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_date</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">gl_date</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
d</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">due_date</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_currency_code</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_amount</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">amount_paid</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">pay_group_lookup_code</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
d</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">payment_priority</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">(SELECT</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">MAX</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">(</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">check_date</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">)</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">FROM</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> ap_checks_all aca</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> ap_invoice_payments_all aip</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">WHERE</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> aca</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">CHECK_ID </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> aip</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">CHECK_ID </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> aip</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_id </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_id</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">)</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">"Last Payment Made on"</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">cancelled_date</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">FROM</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> apps</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">ap_invoices_all </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
apps</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">ap_suppliers
b</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
apps</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">ap_supplier_sites_all
c</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
apps</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">ap_payment_schedules_all
d</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
apps</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">ap_invoice_payments_all
ap</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
ap_checks_all ac</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">WHERE</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">vendor_id </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> b</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">vendor_id</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">vendor_site_id </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> c</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">vendor_site_id</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> b</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">vendor_id </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> c</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">vendor_id</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_id </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> d</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_id</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> ap</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_id </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_id</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> ac</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">CHECK_ID </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> ap</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">CHECK_ID</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">and</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> ac</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">STATUS_LOOKUP_CODE </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"><></span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">'VOIDED'</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">org_id </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">89</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">and</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">invoice_id</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">=</span><span style="background: white; color: maroon; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> 1234</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">a.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">pay_group_lookup_code </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">IN</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">(</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">'DISTRIBUTOR')</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"></span></div>
<div class="MsoNormal">
<span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">
</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> ac</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">.</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">check_date </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">BETWEEN</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">TO_DATE</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">(</span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">'01-Apr-2014'</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">'DD-MON-YYYY'</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">)</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">AND</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">TO_DATE</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">(</span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">'30-Jun-2014 23:59:59'</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">,</span><span style="background: white; color: black; font-family: Courier; font-size: 10.0pt; mso-highlight: white;"> </span><span style="background: white; color: red; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">'DD-MON-YYYY HH24:MI:SS'</span><span style="background: white; color: blue; font-family: Courier; font-size: 10.0pt; mso-highlight: white;">)</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-65912742703199736122015-01-28T17:57:00.001+05:302015-01-28T17:57:51.180+05:30Query to find the parent request id recursivelySELECT request_id,<br />
description<br />
FROM fnd_concurrent_requests<br />
WHERE NVL (request_type, 'X') = 'M'<br />
CONNECT BY PRIOR parent_request_id = request_id<br />
START WITH request_id = &RequestID;Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-76535802823470486542014-11-19T14:12:00.001+05:302014-11-19T14:14:03.409+05:30Credit Card Validation Oracle EBS R12<h4>
Introduction</h4>
Have you ever encountered the below validation failure for credit card in EBS R12.
<br />
<br />
<ul>
<li>Validation failed for the field - Credit Card</li>
<li>Unable to set up a Credit Card Bank Account for the Customer. Credit Card information on the order is not valid.</li>
</ul>
Below is the sample block you can use to validate your credit card in Oracle EBS.<br />
<br />
<br />
We will use standard Oracle Package and Lookup to validate them
<br />
<br />
<ul>
<li>Package : iby_cc_validate</li>
<li>Oe Lookup : Credit Card</li>
</ul>
<h4>
Sample Block</h4>
<div>
<b><i>SET serveroutput ON;</i></b><br />
<b><i><br /></i></b>
<b><i>DECLARE</i></b><br />
<b><i> v_fill_chars VARCHAR (3) := '*-#';</i></b><br />
<b><i> v_cc_number VARCHAR (50) := '1234567812345678';</i></b><br />
<b><i> --'4111*1111 1111-1111#';</i></b><br />
<b><i> v_api_version NUMBER := 1.0;</i></b><br />
<b><i> v_init_msg_list VARCHAR2 (20000) := ' ';</i></b><br />
<b><i> v_return_status VARCHAR2 (20000);</i></b><br />
<b><i> v_msg_count NUMBER;</i></b><br />
<b><i> v_msg_data VARCHAR2 (20000);</i></b><br />
<b><i> v_clean_cc VARCHAR (50);</i></b><br />
<b><i> v_cc_type iby_cc_validate.cctype;</i></b><br />
<b><i> v_cc_valid BOOLEAN;</i></b><br />
<b><i> v_expr_date DATE := SYSDATE ();</i></b><br />
<b><i> v_error_flag VARCHAR2(1) := 'N';</i></b><br />
<b><i> </i></b><br />
<b><i>BEGIN</i></b><br />
<b><i> -- Procedure Call to strip unwanted and special characters</i></b><br />
<b><i> -- checks that illegal characters were not found</i></b><br />
<b><i> </i></b><br />
<b><i> iby_cc_validate.stripcc (v_api_version ,</i></b><br />
<b><i> v_init_msg_list,</i></b><br />
<b><i> v_cc_number,</i></b><br />
<b><i> v_fill_chars,</i></b><br />
<b><i> v_return_status,</i></b><br />
<b><i> v_msg_count,</i></b><br />
<b><i> v_msg_data,</i></b><br />
<b><i> v_clean_cc );</i></b><br />
<b><i> </i></b><br />
<b><i> </i></b><br />
<b><i> IF v_return_status = fnd_api.g_ret_sts_unexp_error THEN</i></b><br />
<b><i> v_error_flag := 'Y';</i></b><br />
<b><i> END IF;</i></b><br />
<b><i> </i></b><br />
<b><i> </i></b><br />
<b><i> -- Procedure Call to validate credit Card Type</i></b><br />
<b><i> iby_cc_validate.getcctype (v_api_version ,</i></b><br />
<b><i> v_init_msg_list ,</i></b><br />
<b><i> v_clean_cc ,</i></b><br />
<b><i> v_return_status ,</i></b><br />
<b><i> v_msg_count ,</i></b><br />
<b><i> v_msg_data ,</i></b><br />
<b><i> v_cc_type );</i></b><br />
<b><i> </i></b><br />
<b><i> </i></b><br />
<b><i> IF v_return_status = fnd_api.g_ret_sts_unexp_error AND v_cc_type = iby_cc_validate.c_invalidcc THEN</i></b><br />
<b><i> dbms_output.put_line ('Credit card number type is invalid');</i></b><br />
<b><i> v_error_flag := 'Y';</i></b><br />
<b><i> ELSE</i></b><br />
<b><i> dbms_output.put_line ('Credit card Type is Valid.');</i></b><br />
<b><i> END IF;</i></b><br />
<b><i> </i></b><br />
<b><i> </i></b><br />
<b><i> -- Procedure Call to validate credit card structure</i></b><br />
<b><i> iby_cc_validate.validatecc (v_api_version ,</i></b><br />
<b><i> v_init_msg_list ,</i></b><br />
<b><i> v_clean_cc ,</i></b><br />
<b><i> v_expr_date ,</i></b><br />
<b><i> v_return_status ,</i></b><br />
<b><i> v_msg_count ,</i></b><br />
<b><i> v_msg_data ,</i></b><br />
<b><i> v_cc_valid );</i></b><br />
<b><i> </i></b><br />
<b><i> IF v_cc_valid AND v_return_status != fnd_api.g_ret_sts_unexp_error THEN</i></b><br />
<b><i> dbms_output.put_line ('Credit card structure is valid.');</i></b><br />
<b><i> ELSE</i></b><br />
<b><i> dbms_output.put_line ('Credit card structure is invalid or has expired.');</i></b><br />
<b><i> v_error_flag := 'Y';</i></b><br />
<b><i> END IF;</i></b><br />
<b><i> </i></b><br />
<b><i> -- Functional Call to returns Credit Card Validation Results using Luhn Algorithm</i></b><br />
<b><i> IF iby_cc_validate.CheckCCDigits(v_clean_cc) = 0 THEN</i></b><br />
<b><i> dbms_output.put_line ('Credit card is valid.');</i></b><br />
<b><i> ELSE</i></b><br />
<b><i> dbms_output.put_line ('Credit card is invalid or has expired.');</i></b><br />
<b><i> v_error_flag := 'Y';</i></b><br />
<b><i> END IF;</i></b><br />
<b><i> </i></b><br />
<b><i> </i></b><br />
<b><i>EXCEPTION</i></b><br />
<b><i>WHEN OTHERS THEN</i></b><br />
<b><i> dbms_output.put_line(SQLERRM);</i></b><br />
<b><i>END;</i></b><br />
<b><i><br /></i></b>
<b><i><br /></i></b>
<b><i><br /></i></b></div>
Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-23387507967336782112014-11-18T11:56:00.002+05:302014-11-18T12:01:02.817+05:30Query to find Credit Card Type in EBS R12<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikR1X0ESd0Mn4k5_JI7pWfsVDzI9fz6jr4QqCwycBpwgHPOvz4Q6bqHH8a-ykq5dqXZJYTEEtOcXBkHu2BdIjtV_Jqc9hPpqAjdddV07km6YMLLqDkFQaynAosZ6uO6tAo3e5m2qnoEGE/s1600/credit-cards.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikR1X0ESd0Mn4k5_JI7pWfsVDzI9fz6jr4QqCwycBpwgHPOvz4Q6bqHH8a-ykq5dqXZJYTEEtOcXBkHu2BdIjtV_Jqc9hPpqAjdddV07km6YMLLqDkFQaynAosZ6uO6tAo3e5m2qnoEGE/s1600/credit-cards.jpg" height="240" width="320" /></a>To Check the Valid Credit Card Type in R12. Execute the query below.<br />
<br />
<br />
SELECT lookup_code,<br />
meaning,<br />
enabled_flag,<br />
start_date_active,<br />
end_date_active<br />
FROM oe_lookups<br />
WHERE lookup_type = 'CREDIT_CARD';<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com1tag:blogger.com,1999:blog-7580318270837714276.post-16853602898891042262014-11-09T17:43:00.000+05:302014-11-09T17:43:11.317+05:30Types of Invoice Class in AR Transaction <b>Invoice </b>: A document that you create that lists amounts owed for the purchases of goods or services, any tax, freight charges and payment terms.<br />
<br />
<b>Credit Memo</b> : A document that partially or fully reverses an original invoice.<br />
<br />
<b>Debit Memo</b> : Debits that you assign to a customer to collect additional charges .<br />
<br />
<b>ChargeBack</b> : A new debit item that you assign to your customer when closing an existing, outstanding debit item.<br />
<br />
<b>Deposit </b>: A type of commitment whereby a customer agrees to deposit or prepay a sum of money for the future purchase of goods and services.<br />
<br />
<b>Guarantee </b>: A contractual obligation to purchase a specified amount of goods or services over a predefined period of time.Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com6tag:blogger.com,1999:blog-7580318270837714276.post-17796999905158519002014-10-27T12:33:00.001+05:302014-10-27T12:41:46.429+05:30Cash Flow Statements : Accounting Basics Day 9<h2>
Introduction
</h2>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWz_wwxWWTqHezplPg93TwDWpcHLwr9kAetZES6UCfd6lGcSN4AtxPDki6ZVT8KJxjWngxn37SB_hTQAYEpvk-sb32MlLmVckvm0gyzGaNqnJeB7DDFyK2LWLYLzKyvlIyQelUXVEa7hE/s1600/cash-flow-statement.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWz_wwxWWTqHezplPg93TwDWpcHLwr9kAetZES6UCfd6lGcSN4AtxPDki6ZVT8KJxjWngxn37SB_hTQAYEpvk-sb32MlLmVckvm0gyzGaNqnJeB7DDFyK2LWLYLzKyvlIyQelUXVEa7hE/s1600/cash-flow-statement.jpg" height="278" width="320" /></a></div>
Cash flow statement provides considerable information about what is really happening
in a business beyond that contained in either the income statement or the balance
sheet. Analyzing this statement will quickly become obvious that the benefits of
understanding the sources and uses of a company’s cash far outweigh the costs of
undertaking some very straightforward analyses. In this chapter we are going to learn
about the preparation of the cash flow statements.<br />
<h3>
What are Cash Flow Statements?
</h3>
Cash flow statement, which shows inflows and outflows of the cash and cash
equivalents. This statement is usually prepared by a company as a tool to know about
the sources and uses of cash and cash equivalents of an enterprise over a period of time
from various activities of an enterprise. It has gained substantial importance in the last
decade because of its practical utility to the users of financial information.
<br />
<h3>
Who Requires a Cash Flow Statement?
</h3>
<br />
<ul>
<li>Executives require knowing if the cash generated by the company will be sufficient to
fund their expansion strategy</li>
<li>Stockholders will be able to know if the firm is generating enough cash to pay
dividends</li>
<li>Suppliers would be interested to know if their customers will be able to pay, on
offering credit</li>
</ul>
<br />
<h3>
Division of Cash Flow Statements
</h3>
The cash flow statement is divided into three sections
<br />
<br />
<ol>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlPMHs8NytOcxSH-QEei6GFOMmh-IvyUhhkdC2upxFTIO2OUMD4x4rhtT9ghT0YoRBmasRyl3vDVTSkSG2d_XKIXkq1-OL9A_jEP4A7RsbZF297N-x6PKq3cNOl61Hxr5vmQH7omAuP-k/s1600/Cash-Flow-statement-1.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlPMHs8NytOcxSH-QEei6GFOMmh-IvyUhhkdC2upxFTIO2OUMD4x4rhtT9ghT0YoRBmasRyl3vDVTSkSG2d_XKIXkq1-OL9A_jEP4A7RsbZF297N-x6PKq3cNOl61Hxr5vmQH7omAuP-k/s1600/Cash-Flow-statement-1.jpg" height="224" width="320" /></a>
<li><b>Operating activities</b> - Converts the items reported on the income statement from the
accrual basis of accounting to cash. Shows the results of cash inflows and outflows
related to the fundamental operations of the basic line or lines of business in which the
company engages. (Example: cash receipts from the sale of goods or services and cash
outflows for purchasing inventory and paying rent and taxes.)</li>
<li><b>Investing activities</b> - Reports the purchase and sale of long-term investments and
property, plant and equipment.</li>
<li><b>Financing activities</b> - Reports the issuance and repurchase of the company's own
bonds and stock and the payment of dividends.</li>
</ol>
<br />
<h3>
Detecting changes in cash with change in various accounts
</h3>
<br />
<ul>
<li> When an asset (other than cash) increases, the Cash account decreases.</li>
<li> When an asset (other than cash) decreases, the Cash account increases.</li>
<li> When a liability increases, the Cash account increases.</li>
<li> When a liability decreases, the Cash account decreases.</li>
<li> When owner's equity increases, the Cash account increases.</li>
<li> When owner's equity decreases, the Cash account decreases.</li>
</ul>
<br />
The differences in a company's balance sheet accounts will provide much of the needed
information. For example, if the statement of cash flows is for the year 2009, the balance
sheet accounts at December 31, 2009 will be compared to the balance sheet accounts
at December 31, 2008. The changes—or differences—in these account balances will
likely be entered in one of the sections of the statement of cash flows.
<br />
<h3>
Cash Provided From or Used By Operating Activities
</h3>
Operating activities are the activities that constitute the primary or main activities of an
enterprise, for example, for a company manufacturing garments, procurement of raw
material, incurrence of manufacturing expenses, sale of garments, etc. These are the
principal revenue producing activities (or the main activities) of the enterprise and
other activities that are not investing or financing activities. By Operating Activities
This section of the cash flow statement reports the company's net income and then
converts it from the accrual basis to the cash basis by using the changes in the balances
of current asset and current liability accounts, such as:
<br />
<br />
<i>Accounts Receivable
</i><br />
<i>Inventory
</i><br />
<i>Supplies
</i><br />
<i>Prepaid Insurance
</i><br />
<i>Other Current Assets
</i><br />
<i>Notes Payable (generally due within one year)
</i><br />
<i>Accounts Payable
</i><br />
<i>Wages Payable
</i><br />
<i>Payroll Taxes Payable
</i><br />
<i>Interest Payable
</i><br />
<i>Income Taxes Payable
</i><br />
<i>Unearned Revenues
</i><br />
<i>Other Current Liabilities
</i><br />
<i><br /></i>
In addition to using the changes in current assets and current liabilities, the operating
activities section has adjustments for depreciation expense and for the gains and losses
on the sale of long-term assets.
<br />
<h3>
Cash Provided From or Used By Investing Activities
</h3>
Investing activities relate to purchase and sale of long-term assets or fixed assets such
as machinery, furniture, land and building, etc. Transactions related to long-term
investment are also investing activities.
<br />
This section of the cash flow statement reports changes in the balances of long-term
asset accounts, such as:
<br />
<br />
<b>Long-term Investments
</b><br />
<i>Land
</i><br />
<i>Buildings
</i><br />
<i>Equipment
</i><br />
<i>Furniture & Fixtures
</i><br />
<i>Vehicles
</i><br />
In short, investing activities involve the purchase and/or sale of long-term investments
and property, plant, and equipment.
<br />
<h3>
Cash provided from or used by financing activities
</h3>
Financing activities relate to long-term funds or capital of an enterprise, e.g. cash
proceeds from issue of equity shares, debentures, raising long-term bank loans,
redemption of bank loan, etc
<br />
This section of the cash flow statement reports changes in balances of the long-term
liability and stockholders' equity accounts, such as:
<br />
<br />
<i>Notes Payable (generally due after one year)
Bonds Payable</i><br />
<i>Deferred Income Taxes</i><br />
<i>Preferred Stock</i><br />
<i>Paid-in Capital in Excess of Par-Preferred Stock</i><br />
<i>Common Stock</i><br />
<i>Paid-in Capital in Excess of Par-Common Stock</i><br />
<i>Paid-in Capital from Treasury Stock</i><br />
<i>Retained Earnings</i><br />
<i>Treasury Stock</i><br />
<i><br /></i>
In short, financing activities involve the issuance and/or the repurchase of a company's
own bonds or stock. Dividend payments are also reported in this section.
<br />
Where to enter the balance sheet changes
<br />
Below are the changes where balance sheet accounts should be entered on Statement
of cash flows:
<br />
<br />
<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style><br />
<table class="tableizer-table">
<tbody>
<tr class="tableizer-firstrow"><th>A change in this</th><th>...is reported in this section</th></tr>
<tr><td>balance sheet category</td><td>of the cash flow statement</td></tr>
<tr><td>Current Assets </td><td>Operating Activities</td></tr>
<tr><td>Current Liabilities </td><td>Operating Activities</td></tr>
<tr><td>Long-term Assets </td><td>Investing Activities</td></tr>
<tr><td>Long-term Liabilities </td><td>Financing Activities</td></tr>
<tr><td>Stockholders' Equity</td><td>Financing Activities</td></tr>
</tbody></table>
<br />
*This refers to current assets other than Cash.<br />
<br />
<br />
<b><i>--Coming Soon -- Preparation of Cash Flow Statement --</i></b>Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com1tag:blogger.com,1999:blog-7580318270837714276.post-20391667938992507932014-10-17T10:54:00.001+05:302014-10-17T10:54:14.725+05:30Query to derive Qualifier Attribute and Context from Modifier Name<b><u>Query :</u></b><br />
<b><i><br /></i></b>
<b><i>SELECT </i></b><br />
<b><i> c.list_line_no "Modifier Line No",</i></b><br />
<b><i> b.name "Modifier Name",</i></b><br />
<b><i> b.description "Modifier Description",</i></b><br />
<b><i> a.qualifier_context,</i></b><br />
<b><i> a.qualifier_attribute,</i></b><br />
<b><i> a.qualifier_attr_value</i></b><br />
<b><i>FROM qp_qualifiers_v a,</i></b><br />
<b><i> qp_list_headers b,</i></b><br />
<b><i> qp_list_lines c</i></b><br />
<b><i>WHERE a.list_header_id=b.list_header_id</i></b><br />
<b><i>and c.list_header_id=b.list_header_id</i></b><br />
<b><i>and c.list_line_id = a.list_line_id</i></b><br />
<b><i>and b.name = &Modifier_Name</i></b><br />
<b><i>ORDER BY a.creation_date DESC;</i></b><br />
<b><i><br /></i></b>
<b><i><br /></i></b>
<b><i><br /></i></b>Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-12256610727516652332014-10-15T14:34:00.001+05:302014-10-15T14:38:59.578+05:30The Treatment given to Adjusting entriesBelow is the chart to identify how adjusting entities are marked in accounting.<br />
<div>
<br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhq42lzKQJg9HWkX6EzUJV2_fLI1z8pmyRuFyAxzmierENtAVN-l7G2GzJmC2VAnY0yxZ5z6-dtucJ5Z2PPYgb_Xibiy-H7Olcr1YV9cf2yb2cR6IWxhTR2zYMIKV71U5z9wzZxc8xat7g/s1600/Adjusting+Entries.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhq42lzKQJg9HWkX6EzUJV2_fLI1z8pmyRuFyAxzmierENtAVN-l7G2GzJmC2VAnY0yxZ5z6-dtucJ5Z2PPYgb_Xibiy-H7Olcr1YV9cf2yb2cR6IWxhTR2zYMIKV71U5z9wzZxc8xat7g/s1600/Adjusting+Entries.png" height="640" width="465" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="http://www.oracleappstoday.com/2014/10/adjusting-entries-accounting-basics-day.html">Click here to go back to Accounting Basics Day 8</a></div>
<div>
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-44883003102769930532014-10-14T11:05:00.002+05:302014-10-27T12:38:33.092+05:30Adjusting Entries : Accounting Basics Day 8<h4>
Introduction </h4>
Adjusting Entries are journal entries made at the end of the accounting period to
allocate revenue and expenses to the period in which they actually are applicable. The
Adjusting entries emphasize that while ascertaining the profitability, the revenues be
considered as they are earned and not based on receipts, and the expenses be
considered as they are incurred and not when they are paid Hence, many items need
some adjustment while preparing the financial statements. In this chapter we’ll discuss
all items which require adjustments and the way these are brought into the books of
account and incorporated in the final accounts
<br />
<h4>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKBkYcj6K9vNeE6YbkqckClxUtRq9fXe4sh8yfIx6d1YuRuajoCuRrjUgEYM1E8KgjHolTrdxhH2WD6u7T1hmBZmTf7_n1IszExMiSwn0VhnqIbQrtmk13dwIdqJH5IfX50aL2jN0yww0/s1600/quick-look-at-adjusting-entries.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKBkYcj6K9vNeE6YbkqckClxUtRq9fXe4sh8yfIx6d1YuRuajoCuRrjUgEYM1E8KgjHolTrdxhH2WD6u7T1hmBZmTf7_n1IszExMiSwn0VhnqIbQrtmk13dwIdqJH5IfX50aL2jN0yww0/s1600/quick-look-at-adjusting-entries.jpg" height="203" width="320" /></a>
What are adjusting entries?
</h4>
Adjusting entries are accounting journal entries that convert a company's accounting
records to the accrual basis of accounting(we have learnt about the accrual basis of
accounting in the previous chapters) .An adjusting journal entry is typically made just
prior to issuing a company's financial statements.
<br />
There are two scenarios where adjusting journal entries are needed before the financial
statements are issued:
<br />
<br />
<br />
<ul>
<li>Nothing has been entered in the accounting records for certain expenses or
revenues, but those expenses and/or revenues did occur and must be included
in the current period's income statement and balance sheet.</li>
<li>Something has already been entered in the accounting records, but the amount
needs to be divided up between two or more accounting periods.</li>
</ul>
<br />
Adjusting entries almost always involve a<br />
<br />
<ul>
<li>Balance sheet account (Interest Payable, Prepaid Insurance, Accounts
Receivable, etc.) and an
Income statement account (Interest Expense, Insurance Expense, Service
Revenues, etc.)</li>
</ul>
<br />
<h4>
Types of Adjusting Entries
</h4>
Some important and common items, which need to be adjusted at the time of
preparing the final accounts, are discussed below.
<br />
<br />
<ol>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzJfdnzPMgkDYrNwUsj8V3cGlsgeZE302UauMeEQx5syFuibJmBEhokI7X4qUlCHvRvznPfh5gGdqwetmRN655_c2oPr2ZFl0kQ0M5QiGV3b36ufT83rongN_5dkEeYVfamGgBRJY9Els/s1600/Adjusting+Entries.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzJfdnzPMgkDYrNwUsj8V3cGlsgeZE302UauMeEQx5syFuibJmBEhokI7X4qUlCHvRvznPfh5gGdqwetmRN655_c2oPr2ZFl0kQ0M5QiGV3b36ufT83rongN_5dkEeYVfamGgBRJY9Els/s1600/Adjusting+Entries.jpg" height="256" width="320" /></a>
<li>Closing stock</li>
<li>Outstanding expenses</li>
<li>Prepaid Expenses</li>
<li>Accrued incomes</li>
<li>Incomes received in advance</li>
<li>Interest on capital</li>
<li>Interest on drawings</li>
<li>Interest on loan</li>
<li>Interest on investment</li>
<li>Depreciation</li>
<li>Bad Debts</li>
<li>Provision for bad and doubtful debts</li>
<li>Provision for discount on debtors</li>
<li>Provision for discount on creditors.</li>
</ol>
<br />
Note: All adjustments will be given outside the trial balance.
<br />
<h4>
Closing Stock
</h4>
The unsold goods in stock at the end of the accounting period is called as closing stock.
This is to be valued at cost or market price whichever is lower.
<br />
<h4>
Outstanding Expenses
</h4>
Expenses which have been incurred but not yet paid during the accounting period for
which the final accounts are being prepared are called as outstanding expenses.
<br />
<h4>
Prepaid Expenses
</h4>
Expenses which have been paid in advance are called as prepaid
(Unexpired) expenses
<br />
<h4>
Accrued Incomes or Outstanding Incomes
</h4>
Income which has been earned but not received during the accounting period is called
as accrued income.
<br />
<h4>
Incomes Received in Advance
</h4>
Income received during a particular accounting period for the work to be done in future
period is called as income received in advance.
<br />
<h4>
Interest on Capital
</h4>
In order to see whether the business is really earning profit or not, it is desirable to
charge interest on capital at a certain rate.
<br />
<h4>
Interest on Drawings
</h4>
Amount withdrawn by the owner for his personal use is called as drawings. When
interest on capital is allowed, then interest on drawings is charged from the owner.
Interest on drawings is an income for the business and will reduce the capital of the
owner
<br />
<h4>
Interest on Loan (Outstanding)
</h4>
Borrowings from banks, financial institutions and outsiders for business are called loans.
Amount payable towards interest on loan is an expense for the business
<br />
<h4>
Interest on Investment:
</h4>
Interest receivable on investments is an income for the business
<br />
<h4>
Depreciation
</h4>
Depreciation is the reduction in the value of fixed assets due to its use or obsolescence.
Generally depreciation is charged at some percentage on the value of fixed asset.
<br />
<h4>
Bad Debts
</h4>
Debts which cannot be recovered are called bad debts. It is a loss for the business.
<br />
<h4>
Provision for Bad and Doubtful Debts </h4>
Every business suffers a percentage of bad debts over and above the debts definitely
known as irrecoverable and written off as Bad (Bad debts written off). If Sundry debtors
figure is to be shown correctly in the Balance sheet provision for bad and doubtful
debts must be adjusted.
<br />
This Provision for bad and doubtful debts is generally provided at a certain percentage
on Debtors, based on past experience. While preparing final accounts, the bad debts
written off given in adjustment is first deducted from the Sundry debtors then on the
balance amount (Sundry debtors – Bad debt written off) provision for bad and doubtful
debts calculated
<br />
<b><i>Provision for Discount on Debtors
</i></b><br />
To motivate the debtors to make prompt payments, cash discount may be allowed to
them. After providing provision for bad and doubtful debts, the remaining debtors are
called as good debtors. They may pay their dues in time and avail themselves of the
cash discount Permissible. So a provision for discount on good debtors at a certain
percentage may have to be created.
<br />
<b><i>Provision for Discount on Creditors
</i></b><br />
Similar to cash discount allowed to debtors, the firm may have a chance to receive the
cash discount from the creditors for prompt payment. Provision for discount on
Creditors is calculated at a certain percentage on Sundry Creditors.
<br />
<br />
<a href="http://www.oracleappstoday.com/2014/10/the-treatment-given-to-adjusting-entries.html">Treatment Given to Adjusting Entries</a><br />
<br />
<br />
<br />
<a href="http://www.oracleappstoday.com/2014/10/final-accounts-accounting-basics-day-7.html">Click here to go back to Accounting Basics Day 7</a><br />
<a href="http://www.oracleappstoday.com/2014/10/cash-flow-statements-accounting-basics.html">Click here to go to Accounting Basics Day 9</a><br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-12705941441537853802014-10-12T11:28:00.000+05:302014-10-12T11:28:00.236+05:30Balance sheetA Balance sheet or statement of financial position is a summary of the financial balances
of a sole proprietorship, a business partnership or a company. Assets, liabilities and
ownership equity are listed as of a specific date, such as the end of its financial year. A
balance sheet is often described as a snapshot of a company's financial condition. Of
the four basic financial statements, the balance sheet is the only statement which
applies to a single point in time of a business calendar year.<br />
<br />
The purpose of preparing a Balance sheet is
<br />
<br />
<ul>
<li>To know the nature and value of assets of the business</li>
<li>To ascertain the total liabilities of the business.</li>
<li>To know the position of owner’s equity. </li>
</ul>
<br />
The Balance Sheet consists of the assets and liabilities of a company, the format of the
Balance Sheet is shown below
<br />
<h4>
Format:
</h4>
Balance Sheet As on xx-xx-20xx of Ms.XX<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZdXXuThDeomeJcH7f2Kv_rDYT-nt7eshqhCDJ_cxoNVwVqIpVTaUt4BjhHek9pKbvXshR7lZ9wxUMRhdVbiu6HkvUY8A8aZdm8HHbODSdLnsVvE1lhSnG22DgmriDkfrU0VKAMvrQgAM/s1600/Balance+Sheet+1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZdXXuThDeomeJcH7f2Kv_rDYT-nt7eshqhCDJ_cxoNVwVqIpVTaUt4BjhHek9pKbvXshR7lZ9wxUMRhdVbiu6HkvUY8A8aZdm8HHbODSdLnsVvE1lhSnG22DgmriDkfrU0VKAMvrQgAM/s1600/Balance+Sheet+1.png" height="395" width="400" /></a></div>
<br />
<h4>
Assets
</h4>
Assets represents everything which a business owns and has money value. In other
words, asset includes possessions and properties of the business. Assets are classified as
follows:
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhI7qfjDtpsbLABZGZ3I3fmVAwnSKp_FBUU_iRjgED-mIGEvMDLizHTWK_K441IGFRXm_Nl-3qrpnkATQ-4NSqfHaKTnV6CkDM0sPzyaJM72CYhICfHG7XVyHTtgsNP6xN1gIUuHOdK6eY/s1600/Balance+Sheet2.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhI7qfjDtpsbLABZGZ3I3fmVAwnSKp_FBUU_iRjgED-mIGEvMDLizHTWK_K441IGFRXm_Nl-3qrpnkATQ-4NSqfHaKTnV6CkDM0sPzyaJM72CYhICfHG7XVyHTtgsNP6xN1gIUuHOdK6eY/s1600/Balance+Sheet2.bmp" height="230" width="400" /></a></div>
<br />
<i><b><u>Tangible Assets:
</u></b></i><br />
Assets which have some physical existence are known as tangible assets. They can be
seen, touched and felt, e.g. Plant and Machinery Tangible assets are classified into
<br />
<br />
<ul>
<li><b>Fixed assets:</b> Assets which have long period of life and cannot be converted into cash in a short
period are termed as fixed assets.</li>
<li><b>Current assets:</b> Assets which can be converted into cash in the ordinary course of business and are held
for a short period are known as current assets. For example, cash in hand, cash at bank,
sundry debtors etc.</li>
</ul>
<b><u><i>Intangible Assets
</i></u></b><br />
The assets which have no physical existence and cannot be seen or felt. They help to
generate revenue in future, e.g. goodwill, patents, trademarks etc.<br />
<br />
<h4>
Liabilities
</h4>
The amount which a business owes to others is liabilities. Credit balances of personal
and real accounts together with the capital account are liabilities.
<br />
<br />
<ul>
<li><b>Long Term Liabilities :</b> Liabilities which are repayable after a long period of time are known as Long Term
Liabilities. For example, capital, long term loans etc.</li>
<li><b>Current Liabilities :</b> Current liabilities are those which are repayable within a year. For example, creditors for
goods purchased, short term loans etc.</li>
<li><b>Contingent liabilities : </b>It is an anticipated liability which may or may not arise in future. For example, liability
arising for bills discounted. Contingent liabilities will not appear in the balance sheet.</li>
</ul>
From the following Trial Balance of M/s. Arjun & Sons, prepare trading and profit and
loss account for the year ending on 31st March 2008 and the balance sheet as on the
date:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjshrBt5U70lJ6yFmblMIXikFZ7Zl0TyJMn8Dp_jziEApJ1_RYyGEs7XJL1OZYMOYxM5wOGLPfWKzG5yTWoJctFto2bTTonwMc7S9VOcpJhXP0S_irT_LfUMjYzxvOylFemCOPT-UwXKMY/s1600/Balance+Sheet+3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjshrBt5U70lJ6yFmblMIXikFZ7Zl0TyJMn8Dp_jziEApJ1_RYyGEs7XJL1OZYMOYxM5wOGLPfWKzG5yTWoJctFto2bTTonwMc7S9VOcpJhXP0S_irT_LfUMjYzxvOylFemCOPT-UwXKMY/s1600/Balance+Sheet+3.png" height="400" width="387" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSxwzqsjKhUUCYPzhd97TGGzlXjKNCaFYIcYbqYCBuSo4y18XnVIvGiGypiOGccz7rmnqxE-c-y7_YPGl6051G713TUwO0MN-eSxnd4EBm7DGGOHB79OAIYoUPA_QtoZWbG2y27j-nRcQ/s1600/Balance+Sheet+4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSxwzqsjKhUUCYPzhd97TGGzlXjKNCaFYIcYbqYCBuSo4y18XnVIvGiGypiOGccz7rmnqxE-c-y7_YPGl6051G713TUwO0MN-eSxnd4EBm7DGGOHB79OAIYoUPA_QtoZWbG2y27j-nRcQ/s1600/Balance+Sheet+4.png" height="400" width="325" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="http://www.oracleappstoday.com/2014/10/final-accounts-accounting-basics-day-7.html">Click here to go back to Accounting Basics Day 7</a></div>
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-13371832483213134222014-10-11T11:33:00.000+05:302014-10-11T11:33:00.168+05:30 Profit and Loss Account<br />
After calculating the gross profit or gross loss the next step is to prepare the profit and
loss account. To earn net profit a trader has to incur many expenses apart from those
spent for purchases and manufacturing of goods. If such expenses are less than gross
profit, the result will be net profit. When total of all these expenses are more than gross
profit the result will be net loss.
<br />
<br />
The aim of profit and loss account is to ascertain the net profit earned or net loss
suffered during a particular period.
<br />
<br />
The Format of Profit and Loss Account is shown below
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitmiNGriOydj053nUsZJnXuFLTOV1AwYidNpIDRXy1ABQE-G6C3t1fws_OB7hLmTo1-dp0GNyfTDEQlcyUEmqxCe_qyrQ_i4dd0pfhBtlMqj-rx1vmkQp3j-v4t0fwr9Olu8-qrkM6G2Y/s1600/Profit+and+Loss+Account.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitmiNGriOydj053nUsZJnXuFLTOV1AwYidNpIDRXy1ABQE-G6C3t1fws_OB7hLmTo1-dp0GNyfTDEQlcyUEmqxCe_qyrQ_i4dd0pfhBtlMqj-rx1vmkQp3j-v4t0fwr9Olu8-qrkM6G2Y/s1600/Profit+and+Loss+Account.png" height="400" width="318" /></a></div>
<br />
<h4>
Items appearing in the debit side
</h4>
Those expenses which are chargeable to the normal activities of the business are
recorded in the debit side of profit and loss account.
<br />
They are termed as I<b>ndirect expenses.
</b><br />
<br />
<ul>
<li><b>Office and Administrative Expenses:</b> Expenses incurred for the functioning of an
office are office and administrative expenses – office salaries, office rent, office lighting,
printing and stationery, postages, telephone charges etc.</li>
<li><b>Repairs and Maintenance Expenses:</b> These expenses relates to the maintenance
of assets - repairs and renewals, depreciation etc.</li>
<li><b>Financial Expenses:</b> Expenses incurred on borrowings –Interest paid on loan</li>
<li><b>Selling and Distribution Expenses:</b> All expenses relating to sales and distribution
of goods - advertising, travelling expenses, salesmen salary, commission paid to
salesmen, discount allowed, repacking charges etc.</li>
</ul>
<h4>
Items appearing in the credit side
</h4>
Besides the gross profit, other gains and incomes of the business are shown on the
credit side. The following are some of the incomes and gains.
<br />
<br />
<ul>
<li>Interest received on investment</li>
<li>Interest received on fixed deposits.</li>
<li>Discount earned.</li>
<li>Commission earned.</li>
<li>Rent Received</li>
</ul>
<h4>
Example</h4>
<br />
<div>
Let us now prepare Trading and Profit Loss Account for the year ending 31st March 2002</div>
<div>
from the books of Mr. Sree Ram</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy63uDeqmQS9I079GPlKPJoxVzcyDbTL244VkN_rNOn23dsAttGPzsT8Dd_fmbI9S5U5M9xisA4MWSnY6eiCgpguy1adeezo3Xy37bJB7sG6-7s0Gd9TyZ98gMsQpHsiPc67RsArF1mjY/s1600/Profit+and+Loss+Account+1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy63uDeqmQS9I079GPlKPJoxVzcyDbTL244VkN_rNOn23dsAttGPzsT8Dd_fmbI9S5U5M9xisA4MWSnY6eiCgpguy1adeezo3Xy37bJB7sG6-7s0Gd9TyZ98gMsQpHsiPc67RsArF1mjY/s1600/Profit+and+Loss+Account+1.png" height="141" width="400" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD0D_pPaBR7jZLo436SjO93RSyNoG921kRNqDQOeAsbh3DPirERpQkVN2dqwB25vw1QXcBz0p8wFxxqZzwvK8qPNKaZhH9eyOC9MbMqRvnzeGCu4JY45lz9dFMpLA6bVFsBT7neVrueHA/s1600/Profit+and+Loss+Account2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD0D_pPaBR7jZLo436SjO93RSyNoG921kRNqDQOeAsbh3DPirERpQkVN2dqwB25vw1QXcBz0p8wFxxqZzwvK8qPNKaZhH9eyOC9MbMqRvnzeGCu4JY45lz9dFMpLA6bVFsBT7neVrueHA/s1600/Profit+and+Loss+Account2.png" height="321" width="400" /></a></div>
<div>
<h4>
Balancing of Income statement
</h4>
The difference between the two sides of profit and loss account indicates either net
profit or net loss. If the total on the credit side is more the difference is called net profit.
On the other hand if the total of debit side is more the difference represents net loss.
The net profit or net loss is transferred to capital account.
<br />
<h4>
Closing Entries
</h4>
Profit and loss account should be closed by transferring the net profit or net loss to
capital account.
<br />
<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style><br />
<table class="tableizer-table">
<tbody>
<tr class="tableizer-firstrow"><th></th><th></th><th></th><th></th></tr>
<tr><td>If net profit</td><td></td><td></td><td></td></tr>
<tr><td></td><td>Profit and Loss A/c.............Dr</td><td>XXX</td><td></td></tr>
<tr><td></td><td>To Capital A/c (Net profit transferred to capital A/c)</td><td></td><td>XXX</td></tr>
<tr><td>If net loss</td><td></td><td></td><td></td></tr>
<tr><td></td><td>Capital A/c....................Dr.</td><td>XXX</td><td></td></tr>
<tr><td></td><td>To Profit and loss A/c (Net loss transferred to Capital A/c)</td><td></td><td>XXX</td></tr>
</tbody></table>
<br /></div>
<div>
<br />
<a href="http://www.oracleappstoday.com/2014/10/final-accounts-accounting-basics-day-7.html">Click here to go back to Accounting Basics Day 7</a><br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-85470241151910709142014-10-10T11:15:00.000+05:302014-10-10T11:15:00.066+05:30Trading Account<br />
Trading means buying and selling. The trading account shows the result of buying and
selling of goods.
<br />
At the end of each year, it is necessary to ascertain the net profit or net loss. For
this purpose, it is first necessary to know the gross profit or gross loss. The trading
account is prepared to ascertain this. The difference between the selling price and the
cost price of the goods is the gross earning of the business concern. Such gross earning
is called as gross profit. However, when the selling price is less than the cost of goods
purchased, the result is gross loss.
<br />
Let us now look at the format of the trading account
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiA8slkkkRp3jqgvfES60G0KtSkdW5sN3PB4bKHsN8l28Tsqlp8jCjP4EJMl5wl7nug0DCUYf0Sj88_HS44h0-Xz8g-s7ZcmuXoWEi5MPZT4EW_ycjTbjgUOyrM8Tjl0mtmyckk5mXbOBU/s1600/Final+accounts+1.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiA8slkkkRp3jqgvfES60G0KtSkdW5sN3PB4bKHsN8l28Tsqlp8jCjP4EJMl5wl7nug0DCUYf0Sj88_HS44h0-Xz8g-s7ZcmuXoWEi5MPZT4EW_ycjTbjgUOyrM8Tjl0mtmyckk5mXbOBU/s1600/Final+accounts+1.bmp" height="202" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
We’ll now see the explanation for each entity in the trading account.
<br />
<br />
Items appearing in the debit side of trading account
<br />
<br />
<ol>
<li><b>Opening stock: </b>Stock on hand at the beginning of the year is termed as opening
stock. The closing stock of the previous accounting year is treated as the opening stock
of the current accounting year. In the case of new business, there will not be any
opening stock.</li>
<li><b>Purchases:</b> Goods Purchased during the year are included in Purchases, this includes
both cash and credit purchases of goods. All the Purchases which have been purchased and returned back to the dealers due to
some defects or excess are called as purchase returns. Purchase returns must be
deducted from the total purchases to get net purchases.</li>
<li><b>Direct Expenses:</b> Expenses which are incurred from the stage of purchase to the stage
of making the goods in saleable condition are termed as direct expenses. Some of the
direct expenses are:</li>
</ol>
<br />
<br />
<br />
<ul>
<li><b>Wages</b>: It is the amount paid to workers for the amount of labor they do for the organization.</li>
<li><b>Carriage or carriage inwards</b>: It means the transportation charges paid to bring the goods from the place of purchase to the place of business.</li>
<li><b>Octroi Duty</b>: Amount paid to bring the goods within the municipal limits.</li>
<li><b>Customs duty, dock dues, clearing charges, import duty etc</b>.: These expenses are paid to the Government on the goods imported.</li>
<li><b>Other expenses:</b> Fuel, power, lighting charges, oil, grease, waste related to production and packing expenses.</li>
</ul>
<div>
<br /></div>
<h4>
Items appearing in the credit side
</h4>
<b>Sales:</b> This includes both cash and credit sale made during the year. Net sales are
derived by deducting sales return from the total sales.
<br />
<b>Closing stock:</b> Closing stock is the value of goods which remain in the hands of
the trader at the end of the year. It does not appear in the trial balance. It appears
outside the trial balance. (As it appears outside the trial balance, first it will be recorded
in the credit side of the trading account and then shown in the assets side of the
balance sheet)
<br />
<br />
Let us prepare a Trading Account from the following information of a trader.
<br />
<br />
Total purchases made during the year 2003 Rs.2,00,000.
<br />
<br />
Total sales made during the year 2003 Rs.2, 50,000<br />
<br />
<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style><br />
<table class="tableizer-table">
<tbody>
<tr class="tableizer-firstrow"><th>Particulars</th><th>Rs</th><th>Particulars</th><th>Rs</th></tr>
<tr><td>To Purchases</td><td>2,00,000</td><td>By sales</td><td>2,50,000</td></tr>
<tr><td>To Gross Profit c/d</td><td>50,000</td><td></td><td></td></tr>
<tr><td></td><td>2,50,000</td><td></td><td>2,50,000</td></tr>
</tbody></table>
<br />
Let us also try to go through another example and try to learn about the Trading
account in detail
<br />
The following example the information given for the year ending 31st March 2002
<br />
Opening stock Rs. 1, 70,000
<br />
Purchases return Rs. 10,000
<br />
Sales Rs.2, 50,000
<br />
Wages Rs. 50,000
<br />
Sales return Rs. 20,000
<br />
Purchases Rs. 1, 00,000
<br />
Carriage inward Rs. 20,000
<br />
Closing stock Rs. 1, 60,000<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlST1HzGEtKVW46Do0Iv52ulRkfzoxJe5dpriCicmxrnN2S4Iaai6rJ8Zv-jhaxMy0mBjNvN-6ReBAFzp1gHrlP9y91od5jT1UxrvBWkUT1jc6cVqycM2Omq4QzFUlXNDIT0fJZcGYUcM/s1600/Trading+Account.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlST1HzGEtKVW46Do0Iv52ulRkfzoxJe5dpriCicmxrnN2S4Iaai6rJ8Zv-jhaxMy0mBjNvN-6ReBAFzp1gHrlP9y91od5jT1UxrvBWkUT1jc6cVqycM2Omq4QzFUlXNDIT0fJZcGYUcM/s1600/Trading+Account.png" height="211" width="400" /></a></div>
<br />
<a href="http://www.oracleappstoday.com/2014/10/final-accounts-accounting-basics-day-7.html">Click here to go back to Accounting Basics Day 7</a><br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com0tag:blogger.com,1999:blog-7580318270837714276.post-83117125101026443222014-10-09T10:52:00.000+05:302014-10-10T11:30:50.229+05:30Final Accounts : Accounting Basics Day 7<h3>
Introduction
</h3>
The Stakeholders of a company will be interested in knowing whether the business has
resulted in profit or loss and what the financial position of the company is at a given
period. The company can ascertain these by preparing the final accounts. The final
accounts are prepared at the end of the year from the trial balance. In this chapter we
are going to learn in detail about the preparation of Final accounts
<br />
<h3>
What are Final Accounts?
</h3>
The businessman is interested in knowing whether the business has resulted in profit or
loss and what the financial position of the business is at a given period. In short, he
wants to know the profitability and the financial soundness of the business. The trader
can ascertain these by preparing the final accounts. The final accounts are prepared at
the end of the year from the trial balance. Hence the trial balance is said to be the
connecting link between the ledger accounts and the final accounts.
<br />
The final Accounts generally include two statements known as balance sheet and
income statement which are required for external reporting and also for internal needs
of the management like planning, decision-making and control.
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiydYO0AVM0wN6ZJuXEGlGYfQWyk38iHtwie9u2n7VQXJfTU782-cbXD2GN_6aDV84WQa2UrYVQv6DyNW8pcyg3hf_am2rcsaE4DgslvPjaqf7MFSzWtoPkmqBsPaxSPQfO3aMTAar7qZk/s1600/Final+accounts.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiydYO0AVM0wN6ZJuXEGlGYfQWyk38iHtwie9u2n7VQXJfTU782-cbXD2GN_6aDV84WQa2UrYVQv6DyNW8pcyg3hf_am2rcsaE4DgslvPjaqf7MFSzWtoPkmqBsPaxSPQfO3aMTAar7qZk/s1600/Final+accounts.bmp" height="263" width="400" /></a></div>
<br />
<br />
<h3>
Trading and Profit and Loss Accounts (Income statement):
</h3>
The profit and loss account is the accounting report which summarizes the revenues
and expenses and ascertains the profit/loss for a specified accounting period. It also
represents the changes in the owner’s equity between two successive periods
<br />
<h4>
Balance Sheet:
</h4>
The purpose of balance sheet is to show its resources and obligations for acquiring its
resources i.e., assets and liabilities. According to American Institute of Public
Accountants, balance sheet is “a tabular statement of summary of balances (debits and
credits) carried forward after an actual and constructive closing of books of accounts
and kept according to principles of Financial Statements of a Company accounting”.
Balance sheet is the statement prepared on a particular date and shows classified
properties and assets on the right hand side and obligations or liabilities on the left
hand side
<br />
<h4>
Assets
</h4>
Real accounts and Personal accounts (which we have learnt about in the previous
chapters) are capable of being called assets. Any element (account) that is capable of
being liquidated (that is capable of being converted to cash by giving it away) indicates
an asset. Machinery, Furniture, Cash, etc are real accounts that can be called assets.
Debtors represent the persons and organizations who owe to the organization. They
would clear their dues by paying out either in cash or in some other form. Thus Debtors
get liquidated and as such can be called assets.
<br />
<h4>
Liabilities
</h4>
All elements representing liabilities are Personal accounts. An element that is capable of
being cleared by paying out indicates a liability.
<br />
Creditors represent the persons and organization to whom the organization owes. The
organization would clear its due by paying them either in cash or in some other form.
Thus creditors are cleared by paying out and as such can be called liabilities.
<br />
<h3>
How to enter the entries into Balance sheet and Income statements?
</h3>
Before learning to enter the accounts into the Income Statement let us first distinguish
the entries and learn to enter them into the financial statements.
<br />
As we know that the ledger accounts maintained within an organizational accounting
system are classified into three as Personal, Real and Nominal.
<br />
<h4>
Nominal Accounts
</h4>
Nominal accounts are related to expenses, losses, incomes and gains. Since ascertaining
profits or losses involves dealing with incomes, gains, expenses and losses we can
conclude that all the nominal accounts together would give us the information relating
to the profits or losses made by the organization.
<br />
<h4>
Real Accounts
</h4>
Real accounts are related to tangible aspects. In general we can identify that all asset
accounts are real accounts.
<br />
<h4>
Personal Accounts
</h4>
Personal accounts are related to persons and organizations. These are
persons/organization which owe the organization or to whom the organization owes.
In effect they either form creditors (liabilities) or debtors (assets).
<br />
<br />
Since all the nominal accounts have been dealt with in deriving the information relating
to profits and we are left with only the real and personal accounts which represent
either assets or liabilities we can conclude that all the real and personal accounts
together give us the information relating to the position of the organization.
<br />
<br />
<br />
<br />
<ul>
<li><a href="http://www.oracleappstoday.com/2014/10/trading-account.html">Trading Account</a></li>
<li><a href="http://www.oracleappstoday.com/2014/10/profit-and-loss-account.html">Profit and Loss Account</a></li>
<li><a href="http://www.oracleappstoday.com/2014/10/balance-sheet.html">Balance Sheet</a></li>
</ul>
<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/04219608385039972602noreply@blogger.com1