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_TXN_INTERFACE dependencies on RCV_SUPPLY

Line 905: * and the LPN with that in RCV_SUPPLY for the parent trasnaction

901: ----
902: /* FP-J Lot/Serial Support Enhancement
903: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
904: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
905: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
906: * This would be done only if WMS and PO patchset levels are J or higher
907: */
908: CURSOR std_distributions (
909: header_id NUMBER

Line 945: rcv_supply rs,

941: po_line_locations pll,
942: po_lines pl,
943: -- Bug 3444226 The Join with po_headers is unnecessary
944: -- po_headers ph,
945: rcv_supply rs,
946: rcv_shipment_headers rsh,
947: -- rcv_shipment_lines rsl,
948: rcv_transactions rt
949: where rsh.receipt_source_code = 'VENDOR'

Line 1045: rcv_supply rs,

1041: po_line_locations pll,
1042: po_lines pl,
1043: -- Bug 3444226 The Join with po_headers is unnecessary
1044: -- po_headers ph,
1045: rcv_supply rs,
1046: rcv_shipment_headers rsh,
1047: -- rcv_shipment_lines rsl,
1048: rcv_transactions rt
1049: where rsh.receipt_source_code = 'VENDOR'

Line 1154: rcv_supply rs,

1150: ,rs.item_revision
1151: from po_distributions pod,
1152: po_line_locations pll,
1153: po_lines pl,
1154: rcv_supply rs,
1155: rcv_shipment_headers rsh,
1156: rcv_transactions rt
1157: where rsh.receipt_source_code = 'VENDOR'
1158: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)

Line 1241: rcv_supply rs,

1237: SELECT count(*)
1238: FROM po_distributions pod,
1239: po_line_locations pll,
1240: po_lines pl,
1241: rcv_supply rs,
1242: rcv_shipment_headers rsh,
1243: rcv_transactions rt
1244: where rsh.receipt_source_code = 'VENDOR'
1245: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)

Line 1735: * the parent transaction in RCV_SUPPLY if lot number is not NULL

1731:
1732: /* FP-J Lot/Serial Support Enhancement
1733: * If WMS and PO patch levels are J or higher, then we need to:
1734: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
1735: * the parent transaction in RCV_SUPPLY if lot number is not NULL
1736: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
1737: * the parent transaction
1738: * c) Set the value of lot_number to the cursor from that in the cascaded table
1739: * Set the value of lpn_id_to_match to the lpn being delivered (p_lpn_id)

Line 1736: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for

1732: /* FP-J Lot/Serial Support Enhancement
1733: * If WMS and PO patch levels are J or higher, then we need to:
1734: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
1735: * the parent transaction in RCV_SUPPLY if lot number is not NULL
1736: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
1737: * the parent transaction
1738: * c) Set the value of lot_number to the cursor from that in the cascaded table
1739: * Set the value of lpn_id_to_match to the lpn being delivered (p_lpn_id)
1740: * If either of these are not at J, we should retain the original functionality