APPS.GML_RCV_DIR_RCPT_APIS dependencies on RCV_SHIPMENT_HEADERS

Line 1265: RCV_SHIPMENT_HEADERS RSH,

1261: NULL CURRENCY_CONVERSION_DATE_POD,
1262: NULL PROJECT_ID,
1263: NULL TASK_ID
1264: FROM
1265: RCV_SHIPMENT_HEADERS RSH,
1266: RCV_SHIPMENT_LINES RSL,
1267: PO_REQUISITION_HEADERS PORH,
1268: PO_REQUISITION_LINES PORL,
1269: MTL_SYSTEM_ITEMS MSI,

Line 1303: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.

1299:
1300: -- query po_startup_value
1301: Begin
1302: /* Bug #2516729
1303: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
1304: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
1305: * in order that a new receipt # is not created everytime and the existing receipt # is used
1306: */
1307: BEGIN

Line 1310: FROM rcv_shipment_headers

1306: */
1307: BEGIN
1308: SELECT receipt_num
1309: INTO l_receipt_num
1310: FROM rcv_shipment_headers
1311: WHERE shipment_header_id = p_shipment_header_id
1312: AND ship_to_org_id = p_organization_id;
1313:
1314: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

Line 2186: RCV_SHIPMENT_HEADERS RSH,

2182: pod.project_id PROJECT_ID,
2183: pod.task_id TASK_ID
2184: FROM
2185: RCV_SHIPMENT_LINES RSL,
2186: RCV_SHIPMENT_HEADERS RSH,
2187: PO_HEADERS POH,
2188: PO_LINE_LOCATIONS POLL,
2189: PO_LINES POL,
2190: PO_RELEASES POR,

Line 2348: RCV_SHIPMENT_HEADERS RSH,

2344: TO_DATE(NULL) CURRENCY_CONVERSION_DATE_POD,
2345: TO_NUMBER(NULL) PROJECT_ID,
2346: TO_NUMBER(NULL) TASK_ID
2347: FROM
2348: RCV_SHIPMENT_HEADERS RSH,
2349: RCV_SHIPMENT_LINES RSL,
2350: PO_REQUISITION_HEADERS PORH,
2351: PO_REQUISITION_LINES PORL,
2352: MTL_SYSTEM_ITEMS MSI,

Line 2389: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.

2385:
2386: -- query po_startup_value
2387: Begin
2388: /* Bug 2516729
2389: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
2390: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
2391: * in order that a new receipt # is not created everytime and the existing receipt # is used
2392: */
2393: BEGIN

Line 2396: FROM rcv_shipment_headers

2392: */
2393: BEGIN
2394: SELECT receipt_num
2395: INTO l_receipt_num
2396: FROM rcv_shipment_headers
2397: WHERE shipment_header_id = p_shipment_header_id
2398: AND ship_to_org_id = p_organization_id;
2399:
2400: inv_rcv_common_apis.g_rcv_global_var.receipt_num := l_receipt_num;

Line 2802: , rcv_shipment_headers rsh

2798: wlpnc.source_line_id
2799: FROM wms_lpn_contents wlpnc
2800: , wms_license_plate_numbers wlpn
2801: , mtl_system_items msi
2802: , rcv_shipment_headers rsh
2803: WHERE rsh.shipment_header_id = p_shipment_header_id
2804: AND (wlpn.source_header_id = rsh.shipment_header_id
2805: OR wlpn.source_name = rsh.shipment_num)
2806: AND wlpn.lpn_context IN (6, 7) -- only those pre-ASN receiving ones