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.INV_RCV_DIR_RCPT_APIS dependencies on RCV_SHIPMENT_HEADERS

Line 1762: FROM rcv_shipment_headers rsh

1758: , NULL task_id
1759: , NULL secondary_uom --OPM Convergence
1760: , NULL secondary_uom_code --OPM Convergence
1761: , NULL secondary_quantity --OPM Convergence
1762: FROM rcv_shipment_headers rsh
1763: , rcv_shipment_lines rsl
1764: , po_requisition_headers porh
1765: , po_requisition_lines porl
1766: , mtl_system_items msi

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

1827:
1828: -- query po_startup_value
1829: BEGIN
1830: /* Bug #2516729
1831: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
1832: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
1833: * in order that a new receipt # is not created everytime and the existing receipt # is used
1834: */
1835: BEGIN

Line 1838: FROM rcv_shipment_headers

1834: */
1835: BEGIN
1836: SELECT receipt_num
1837: INTO l_receipt_num
1838: FROM rcv_shipment_headers
1839: WHERE shipment_header_id = p_shipment_header_id
1840: AND ship_to_org_id = p_organization_id;
1841:
1842: --Bug 4552825 - Assign the value only if it is not null

Line 3251: , rcv_shipment_headers rsh

3247: , NULL secondary_uom --OPM Convergence
3248: , NULL secondary_uom_code --OPM Convergence
3249: , NULL secondary_quantity --OPM Convergence
3250: FROM rcv_shipment_lines rsl
3251: , rcv_shipment_headers rsh
3252: , po_headers poh
3253: , po_line_locations poll
3254: , po_lines pol
3255: , po_releases por

Line 3415: FROM rcv_shipment_headers rsh

3411: , TO_NUMBER(NULL) task_id
3412: , NULL secondary_uom --OPM Convergence
3413: , NULL secondary_uom_code --OPM Convergence
3414: , NULL secondary_quantity --OPM Convergence
3415: FROM rcv_shipment_headers rsh
3416: , rcv_shipment_lines rsl
3417: , po_requisition_headers porh
3418: , po_requisition_lines porl
3419: , mtl_system_items msi

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

3487:
3488: -- query po_startup_value
3489: BEGIN
3490: /* Bug 2516729
3491: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
3492: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
3493: * in order that a new receipt # is not created everytime and the existing receipt # is used
3494: */
3495: BEGIN

Line 3498: FROM rcv_shipment_headers

3494: */
3495: BEGIN
3496: SELECT receipt_num
3497: INTO l_receipt_num
3498: FROM rcv_shipment_headers
3499: WHERE shipment_header_id = p_shipment_header_id
3500: AND ship_to_org_id = p_organization_id;
3501:
3502: --Bug 4552825 - Assign the value only if it is not null

Line 4161: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh

4157: , wlpnc.lot_number
4158: , wlpnc.source_line_id
4159: , wlpn.organization_id lpn_org_id
4160: , wlpnc.secondary_quantity --Bug 7656734
4161: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh
4162: WHERE rsh.shipment_header_id = p_shipment_header_id
4163: AND (wlpn.source_header_id = rsh.shipment_header_id
4164: OR wlpn.source_name = rsh.shipment_num)
4165: AND wlpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones