APPS.GMF_GMFLCHST_XMLP_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 135: RCV_SHIPMENT_HEADERS R,

131: SELECT
132: DISTINCT
133: MP.ORGANIZATION_CODE || ' ' || R.RECEIPT_NUM
134: FROM
135: RCV_SHIPMENT_HEADERS R,
136: MTL_MATERIAL_TRANSACTIONS P,
137: MTL_PARAMETERS MP
138: WHERE R.SHIPMENT_HEADER_ID = P.TRANSACTION_SOURCE_ID
139: AND R.ORGANIZATION_ID = P.ORGANIZATION_ID

Line 252: rcv_shipment_headers rsh

248: IS
249: SELECT rsh.receipt_num, glat.lc_ship_num
250: FROM gmf_lc_adj_transactions glat,
251: rcv_transactions rt,
252: rcv_shipment_headers rsh
253: WHERE glat.rcv_transaction_id = rt.transaction_id
254: AND rsh.shipment_header_id = rt.shipment_header_id
255: AND glat.adj_transaction_id = l_adj_transaction_id ;
256:

Line 257: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;

253: WHERE glat.rcv_transaction_id = rt.transaction_id
254: AND rsh.shipment_header_id = rt.shipment_header_id
255: AND glat.adj_transaction_id = l_adj_transaction_id ;
256:
257: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
258: l_lc_ship_num gmf_lc_adj_transactions.lc_ship_num%TYPE;
259:
260: BEGIN
261: IF (DOC_TYPE = 'PROD') THEN