eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CODE_CONVERSION_PVT dependencies on OZF_RESALE_ADJUSTMENTS

Line 1132: FROM ozf_resale_adjustments lin

1128: AND orig_system_agreement_name = cv_external_code
1129: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)
1130: UNION
1131: SELECT COUNT(orig_system_agreement_name) pt_cnt
1132: FROM ozf_resale_adjustments lin
1133: ,ozf_resale_batches bat
1134: WHERE orig_system_agreement_name = cv_external_code
1135: AND bat.resale_batch_id = lin.resale_batch_id
1136: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ) x;

Line 1147: FROM ozf_resale_adjustments lin

1143: CURSOR csr_code_conv_agrmt_uom (cv_external_code VARCHAR2
1144: ,cv_party_id NUMBER
1145: ,cv_account_id NUMBER ) IS
1146: SELECT COUNT(orig_system_agreement_uom)
1147: FROM ozf_resale_adjustments lin
1148: ,ozf_resale_batches bat
1149: WHERE orig_system_agreement_uom = cv_external_code
1150: AND bat.resale_batch_id = lin.resale_batch_id
1151: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ;

Line 1155: FROM ozf_resale_adjustments lin

1151: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ;
1152:
1153: CURSOR csr_code_conv_agmt_uom (cv_external_code VARCHAR2 ) IS
1154: SELECT COUNT(orig_system_agreement_uom)
1155: FROM ozf_resale_adjustments lin
1156: WHERE orig_system_agreement_uom = cv_external_code;
1157:
1158: BEGIN
1159: -- Standard Start of API savepoint