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 1760: FROM rcv_shipment_headers rsh

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

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

1816:
1817: -- query po_startup_value
1818: BEGIN
1819: /* Bug #2516729
1820: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
1821: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
1822: * in order that a new receipt # is not created everytime and the existing receipt # is used
1823: */
1824: BEGIN

Line 1827: FROM rcv_shipment_headers

1823: */
1824: BEGIN
1825: SELECT receipt_num
1826: INTO l_receipt_num
1827: FROM rcv_shipment_headers
1828: WHERE shipment_header_id = p_shipment_header_id
1829: AND ship_to_org_id = p_organization_id;
1830:
1831: --Bug 4552825 - Assign the value only if it is not null

Line 3147: , rcv_shipment_headers rsh

3143: , NULL secondary_uom --OPM Convergence
3144: , NULL secondary_uom_code --OPM Convergence
3145: , NULL secondary_quantity --OPM Convergence
3146: FROM rcv_shipment_lines rsl
3147: , rcv_shipment_headers rsh
3148: , po_headers poh
3149: , po_line_locations poll
3150: , po_lines pol
3151: , po_releases por

Line 3311: FROM rcv_shipment_headers rsh

3307: , TO_NUMBER(NULL) task_id
3308: , NULL secondary_uom --OPM Convergence
3309: , NULL secondary_uom_code --OPM Convergence
3310: , NULL secondary_quantity --OPM Convergence
3311: FROM rcv_shipment_headers rsh
3312: , rcv_shipment_lines rsl
3313: , po_requisition_headers porh
3314: , po_requisition_lines porl
3315: , mtl_system_items msi

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

3383:
3384: -- query po_startup_value
3385: BEGIN
3386: /* Bug 2516729
3387: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
3388: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
3389: * in order that a new receipt # is not created everytime and the existing receipt # is used
3390: */
3391: BEGIN

Line 3394: FROM rcv_shipment_headers

3390: */
3391: BEGIN
3392: SELECT receipt_num
3393: INTO l_receipt_num
3394: FROM rcv_shipment_headers
3395: WHERE shipment_header_id = p_shipment_header_id
3396: AND ship_to_org_id = p_organization_id;
3397:
3398: --Bug 4552825 - Assign the value only if it is not null

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

4015: , wlpnc.uom_code
4016: , wlpnc.lot_number
4017: , wlpnc.source_line_id
4018: , wlpn.organization_id lpn_org_id
4019: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh
4020: WHERE rsh.shipment_header_id = p_shipment_header_id
4021: AND (wlpn.source_header_id = rsh.shipment_header_id
4022: OR wlpn.source_name = rsh.shipment_num)
4023: AND wlpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones