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 1119: FROM ozf_resale_adjustments lin

1115: AND orig_system_agreement_name = cv_external_code
1116: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id)
1117: UNION
1118: SELECT COUNT(orig_system_agreement_name) pt_cnt
1119: FROM ozf_resale_adjustments lin
1120: ,ozf_resale_batches bat
1121: WHERE orig_system_agreement_name = cv_external_code
1122: AND bat.resale_batch_id = lin.resale_batch_id
1123: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ) x;

Line 1134: FROM ozf_resale_adjustments lin

1130: CURSOR csr_code_conv_agrmt_uom (cv_external_code VARCHAR2
1131: ,cv_party_id NUMBER
1132: ,cv_account_id NUMBER ) IS
1133: SELECT COUNT(orig_system_agreement_uom)
1134: FROM ozf_resale_adjustments lin
1135: ,ozf_resale_batches bat
1136: WHERE orig_system_agreement_uom = cv_external_code
1137: AND bat.resale_batch_id = lin.resale_batch_id
1138: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ;

Line 1142: FROM ozf_resale_adjustments lin

1138: AND (bat.partner_party_id = cv_party_id OR bat.partner_cust_account_id = cv_account_id) ;
1139:
1140: CURSOR csr_code_conv_agmt_uom (cv_external_code VARCHAR2 ) IS
1141: SELECT COUNT(orig_system_agreement_uom)
1142: FROM ozf_resale_adjustments lin
1143: WHERE orig_system_agreement_uom = cv_external_code;
1144:
1145: BEGIN
1146: -- Standard Start of API savepoint