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 911: * and the LPN with that in RCV_SUPPLY for the parent trasnaction

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

Line 951: rcv_supply rs,

947: po_line_locations_trx_v pll, -- CLM project, bug 9403291
948: po_lines_trx_v pl, -- CLM project, bug 9403291
949: -- Bug 3444226 The Join with po_headers is unnecessary
950: -- po_headers ph,
951: rcv_supply rs,
952: rcv_shipment_headers rsh,
953: -- rcv_shipment_lines rsl,
954: rcv_transactions rt
955: where rsh.receipt_source_code = 'VENDOR'

Line 1051: rcv_supply rs,

1047: po_line_locations_trx_v pll, -- CLM project, bug 9403291
1048: po_lines_trx_v pl, -- CLM project, bug 9403291
1049: -- Bug 3444226 The Join with po_headers is unnecessary
1050: -- po_headers ph,
1051: rcv_supply rs,
1052: rcv_shipment_headers rsh,
1053: -- rcv_shipment_lines rsl,
1054: rcv_transactions rt
1055: where rsh.receipt_source_code = 'VENDOR'

Line 1160: rcv_supply rs,

1156: ,rs.item_revision
1157: from po_distributions_trx_v pod, -- CLM project, bug 9403291
1158: po_line_locations_trx_v pll, -- CLM project, bug 9403291
1159: po_lines_trx_v pl, -- CLM project, bug 9403291
1160: rcv_supply rs,
1161: rcv_shipment_headers rsh,
1162: rcv_transactions rt
1163: where rsh.receipt_source_code = 'VENDOR'
1164: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)

Line 1247: rcv_supply rs,

1243: SELECT count(*)
1244: FROM po_distributions_trx_v pod, -- CLM project, bug 9403291
1245: po_line_locations_trx_v pll, -- CLM project, bug 9403291
1246: po_lines_trx_v pl, -- CLM project, bug 9403291
1247: rcv_supply rs,
1248: rcv_shipment_headers rsh,
1249: rcv_transactions rt
1250: where rsh.receipt_source_code = 'VENDOR'
1251: AND pod.po_line_id = Nvl(v_po_line_id, pod.po_line_id)

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

1767:
1768: /* FP-J Lot/Serial Support Enhancement
1769: * If WMS and PO patch levels are J or higher, then we need to:
1770: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
1771: * the parent transaction in RCV_SUPPLY if lot number is not NULL
1772: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
1773: * the parent transaction
1774: * c) Set the value of lot_number to the cursor from that in the cascaded table
1775: * Set the value of lpn_id_to_match to the lpn being delivered (p_lpn_id)

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

1768: /* FP-J Lot/Serial Support Enhancement
1769: * If WMS and PO patch levels are J or higher, then we need to:
1770: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
1771: * the parent transaction in RCV_SUPPLY if lot number is not NULL
1772: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
1773: * the parent transaction
1774: * c) Set the value of lot_number to the cursor from that in the cascaded table
1775: * Set the value of lpn_id_to_match to the lpn being delivered (p_lpn_id)
1776: * If either of these are not at J, we should retain the original functionality