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_ADJ_NEW_LINE_PVT dependencies on OZF_OFFERS

Line 790: SELECT modifier_level_code FROM ozf_offers a, ozf_offer_adjustments_b b

786: , x_return_status OUT NOCOPY VARCHAR2
787: )
788: IS
789: CURSOR c_modifierLevelCode(cp_offerAdjustmentId NUMBER) IS
790: SELECT modifier_level_code FROM ozf_offers a, ozf_offer_adjustments_b b
791: WHERE a.qp_list_header_id = b.list_header_id
792: AND b.offer_adjustment_id = cp_offerAdjustmentId;
793: l_modifierLevelCode c_modifierLevelCode%ROWTYPE;
794: CURSOR c_dates (cp_offerAdjustmentId NUMBER) IS

Line 1344: SELECT modifier_level_code, a.offer_type FROM ozf_offers a, ozf_offer_adjustments_b b

1340: p_adj_new_prod_rec IN OUT NOCOPY OZF_Adj_New_Prod_PVT.adj_new_prod_rec_type
1341: )
1342: IS
1343: CURSOR c_modifierLevelCode(cp_offerAdjustmentId NUMBER) IS
1344: SELECT modifier_level_code, a.offer_type FROM ozf_offers a, ozf_offer_adjustments_b b
1345: WHERE a.qp_list_header_id = b.list_header_id
1346: AND b.offer_adjustment_id = cp_offerAdjustmentId;
1347: l_modifierLevelCode c_modifierLevelCode%ROWTYPE;
1348: BEGIN