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

1219:
1220: /* FP-J Lot/Serial Support Enhancement
1221: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
1222: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
1223: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
1224: * This would be done only if WMS and PO patchset levels are J or higher
1225: */
1226:
1227: CURSOR int_req_delivery_lines(

Line 1257: FROM rcv_supply rsup

1253: , To_number(NULL) po_line_location_id
1254: , To_number(NULL) po_distribution_id
1255: , rsl.item_description item_description
1256: , Nvl(rsh.expected_receipt_date, Sysdate) expected_receipt_date
1257: FROM rcv_supply rsup
1258: , rcv_transactions rt
1259: , rcv_shipment_headers rsh
1260: , rcv_shipment_lines rsl
1261: WHERE rsl.shipment_header_id = v_shipment_header_id

Line 1338: FROM rcv_supply rsup

1334: ,v_lpn_id_to_match NUMBER
1335: ,v_parent_txn_id_to_match NUMBER)
1336: IS
1337: SELECT COUNT(*)
1338: FROM rcv_supply rsup
1339: , rcv_transactions rt
1340: , rcv_shipment_headers rsh
1341: , rcv_shipment_lines rsl
1342: WHERE rsl.shipment_header_id = v_shipment_header_id

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

1404:
1405: /* FP-J Lot/Serial Support Enhancement
1406: * Added two new arguments to the cursor, v_lot_number and v_lpn_id_to_match
1407: * Added conditions to match the lot number with that in RCV_LOTS_SUPPLY
1408: * and the LPN with that in RCV_SUPPLY for the parent trasnaction
1409: * This would be done only if WMS and PO patchset levels are J or higher
1410: */
1411: CURSOR rma_delivery_lines(
1412: v_oe_order_header_id NUMBER

Line 1441: FROM rcv_supply rsup

1437: , To_number(NULL)
1438: , To_number(NULL)
1439: , To_char(NULL)
1440: , To_char(NULL)
1441: FROM rcv_supply rsup
1442: , rcv_transactions rt
1443: , rcv_shipment_headers rsh
1444: WHERE rsh.receipt_source_code = 'CUSTOMER'
1445: AND rsup.item_id = v_item_id

Line 1510: FROM rcv_supply rsup

1506: ,v_lpn_id_to_match NUMBER
1507: ,v_parent_txn_id_to_match NUMBER)
1508: IS
1509: SELECT COUNT(*)
1510: FROM rcv_supply rsup
1511: , rcv_transactions rt
1512: , rcv_shipment_headers rsh
1513: WHERE rsh.receipt_source_code = 'CUSTOMER'
1514: AND rsup.item_id = v_item_id

Line 1594: FROM rcv_supply rsup

1590: , rsup.po_line_location_id po_line_location_id
1591: , pod.po_distribution_id po_distribution_id
1592: , rsl.item_description item_description
1593: , to_char(null)
1594: FROM rcv_supply rsup
1595: , rcv_transactions rt
1596: , rcv_shipment_headers rsh
1597: , rcv_shipment_lines rsl
1598: , po_line_locations poll

Line 1675: FROM rcv_supply rsup

1671: ,v_parent_transaction_id NUMBER) -- Added for bug# 9879753
1672:
1673: IS
1674: SELECT COUNT(*)
1675: FROM rcv_supply rsup
1676: , rcv_transactions rt
1677: , rcv_shipment_headers rsh
1678: , rcv_shipment_lines rsl
1679: , po_line_locations poll

Line 1769: FROM rcv_supply rsup

1765: , rsup.po_line_location_id po_line_location_id
1766: , pod.po_distribution_id po_distribution_id
1767: , rsl.item_description item_description
1768: , to_char(null)
1769: FROM rcv_supply rsup
1770: , rcv_transactions rt
1771: , rcv_shipment_headers rsh
1772: , rcv_shipment_lines rsl
1773: , po_line_locations poll

Line 1846: FROM rcv_supply rsup

1842: ,v_lot_number VARCHAR2
1843: ,v_lpn_id_to_match NUMBER)
1844: IS
1845: SELECT COUNT(*)
1846: FROM rcv_supply rsup
1847: , rcv_transactions rt
1848: , rcv_shipment_headers rsh
1849: , rcv_shipment_lines rsl
1850: , po_line_locations poll

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

2293:
2294: /* FP-J Lot/Serial Support Enhancement
2295: * If WMS and PO patch levels are J or higher, then we need to:
2296: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
2297: * the parent transaction in RCV_SUPPLY if lot number is not NULL
2298: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
2299: * the parent transaction
2300: * c) Set the value of lot_number to the cursor from that in the cascaded table
2301: * Set the value of lpn_id_to_match to the lpn being delivered (p_lpn_id)

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

2294: /* FP-J Lot/Serial Support Enhancement
2295: * If WMS and PO patch levels are J or higher, then we need to:
2296: * a) Match the lot number with that in RCV_LOTS_SUPPLY for the
2297: * the parent transaction in RCV_SUPPLY if lot number is not NULL
2298: * b) Match the LPN being delivered with the LPN in the RCV_SUPPLY for
2299: * the parent transaction
2300: * c) Set the value of lot_number to the cursor from that in the cascaded table
2301: * Set the value of lpn_id_to_match to the lpn being delivered (p_lpn_id)
2302: * If either of these are not at J, we should retain the original functionality