APPS.CSP_TRANSACTIONS_PUB dependencies on RCV_SHIPMENT_HEADERS

Line 1046: FROM RCV_SHIPMENT_HEADERS M

1042: End if;
1043:
1044: Begin
1045: SELECT SHIPMENT_NUM INTO l_ship_number
1046: FROM RCV_SHIPMENT_HEADERS M
1047: WHERE M.SHIPMENT_NUM = p_shipment_number AND ROWNUM = 1;
1048: Exception
1049: When no_data_found then
1050: l_ship_number := Null;

Line 2384: RCV_SHIPMENT_HEADERS rsh

2380: rsh.waybill_airbill_num,
2381: rsh.RECEIPT_NUM
2382: from
2383: RCV_SHIPMENT_LINES rsl,
2384: RCV_SHIPMENT_HEADERS rsh
2385: where
2386: rsl.shipment_line_id = l_rcv_ship_line_id
2387: and rsh.shipment_header_id = rsl.shipment_header_id
2388: and rsh.receipt_source_code = 'INTERNAL ORDER';