DBA Data[Home] [Help]

APPS.AMS_FULFILL_PVT dependencies on QP_LIST_HEADERS_VL

Line 117: FROM ams_deliverables_vl del,qp_list_headers_vl qp

113:
114: CURSOR c_del_det IS
115: SELECT inventory_item_id, inventory_item_org_id,
116: pricelist_header_id , nvl(qp.currency_code,'USD') currency_code
117: FROM ams_deliverables_vl del,qp_list_headers_vl qp
118: WHERE del.deliverable_id = p_deliv_id
119: AND del.pricelist_header_id = qp.list_header_id ;
120:
121: l_del_rec c_del_det%ROWTYPE ;

Line 126: FROM ams_deliverables_vl del,qp_list_headers_vl qp

122:
123: CURSOR c_kit_det IS
124: SELECT inventory_item_id, inventory_item_org_id,
125: pricelist_header_id , nvl(qp.currency_code,'USD') currency_code
126: FROM ams_deliverables_vl del,qp_list_headers_vl qp
127: WHERE del.deliverable_id = p_deliv_id
128: AND del.pricelist_header_id = qp.list_header_id ;
129:
130: l_kit_rec c_del_det%ROWTYPE ;