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

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

1047:
1048: /* FP-J Lot/Serial Support Enhancement
1049: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
1050: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
1051: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
1052: * This would be done only if WMS and PO patchset levels are J or higher
1053: */
1054:
1055: CURSOR int_req_delivery_lines(

Line 1085: FROM rcv_supply rsup

1081: , To_number(NULL) po_line_location_id
1082: , To_number(NULL) po_distribution_id
1083: , rsl.item_description item_description
1084: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
1085: FROM rcv_supply rsup
1086: , rcv_transactions rt
1087: , rcv_shipment_headers rsh
1088: , rcv_shipment_lines rsl
1089: WHERE rsl.shipment_header_id = v_shipment_header_id

Line 1157: FROM rcv_supply rsup

1153: ,v_lpn_id_to_match NUMBER
1154: ,v_parent_txn_id_to_match NUMBER)
1155: IS
1156: SELECT COUNT(*)
1157: FROM rcv_supply rsup
1158: , rcv_transactions rt
1159: , rcv_shipment_headers rsh
1160: , rcv_shipment_lines rsl
1161: WHERE rsl.shipment_header_id = v_shipment_header_id

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

1213:
1214: /* FP-J Lot/Serial Support Enhancement
1215: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
1216: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
1217: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
1218: * This would be done only if WMS and PO patchset levels are J or higher
1219: */
1220: CURSOR rma_delivery_lines(
1221: v_oe_order_header_id NUMBER

Line 1250: FROM rcv_supply rsup

1246: , To_number(NULL)
1247: , To_number(NULL)
1248: , To_char(NULL)
1249: , To_char(NULL)
1250: FROM rcv_supply rsup
1251: , rcv_transactions rt
1252: , rcv_shipment_headers rsh
1253: WHERE rsh.receipt_source_code = 'CUSTOMER'
1254: AND rsup.item_id = v_item_id

Line 1319: FROM rcv_supply rsup

1315: ,v_lpn_id_to_match NUMBER
1316: ,v_parent_txn_id_to_match NUMBER)
1317: IS
1318: SELECT COUNT(*)
1319: FROM rcv_supply rsup
1320: , rcv_transactions rt
1321: , rcv_shipment_headers rsh
1322: WHERE rsh.receipt_source_code = 'CUSTOMER'
1323: AND rsup.item_id = v_item_id

Line 1402: FROM rcv_supply rsup

1398: , rsup.po_line_location_id po_line_location_id
1399: , pod.po_distribution_id po_distribution_id
1400: , rsl.item_description item_description
1401: , to_char(null)
1402: FROM rcv_supply rsup
1403: , rcv_transactions rt
1404: , rcv_shipment_headers rsh
1405: , rcv_shipment_lines rsl
1406: , po_line_locations poll

Line 1479: FROM rcv_supply rsup

1475: ,v_lot_number VARCHAR2
1476: ,v_lpn_id_to_match NUMBER)
1477: IS
1478: SELECT COUNT(*)
1479: FROM rcv_supply rsup
1480: , rcv_transactions rt
1481: , rcv_shipment_headers rsh
1482: , rcv_shipment_lines rsl
1483: , po_line_locations poll

Line 1572: FROM rcv_supply rsup

1568: , rsup.po_line_location_id po_line_location_id
1569: , pod.po_distribution_id po_distribution_id
1570: , rsl.item_description item_description
1571: , to_char(null)
1572: FROM rcv_supply rsup
1573: , rcv_transactions rt
1574: , rcv_shipment_headers rsh
1575: , rcv_shipment_lines rsl
1576: , po_line_locations poll

Line 1649: FROM rcv_supply rsup

1645: ,v_lot_number VARCHAR2
1646: ,v_lpn_id_to_match NUMBER)
1647: IS
1648: SELECT COUNT(*)
1649: FROM rcv_supply rsup
1650: , rcv_transactions rt
1651: , rcv_shipment_headers rsh
1652: , rcv_shipment_lines rsl
1653: , po_line_locations poll

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

2066:
2067: /* FP-J Lot/Serial Support Enhancement
2068: * If WMS and PO patch levels are J or higher, then we need to:
2069: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
2070: * the parent transaction in RCV_SUPPLY if lot number is not NULL
2071: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
2072: * the parent transaction
2073: * c) Set the value of lot_number to the cursor from that in the cascaded table
2074: * Set the value of lpn_id_to_match to the lpn being delivered (p_lpn_id)

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

2067: /* FP-J Lot/Serial Support Enhancement
2068: * If WMS and PO patch levels are J or higher, then we need to:
2069: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
2070: * the parent transaction in RCV_SUPPLY if lot number is not NULL
2071: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
2072: * the parent transaction
2073: * c) Set the value of lot_number to the cursor from that in the cascaded table
2074: * Set the value of lpn_id_to_match to the lpn being delivered (p_lpn_id)
2075: * If either of these are not at J, we should retain the original functionality