APPS.INV_RCV_STD_DELIVER_APIS dependencies on RCV_SUPPLY

Line 1620: , rcv_supply rsup

1616: --The following columns are needed for matching in cases where no LPN is involved
1617: , rsup.to_subinventory from_subinventory_code
1618: , rsup.to_locator_id from_locator_id
1619: FROM rcv_transactions rt
1620: , rcv_supply rsup
1621: , rcv_shipment_headers rsh
1622: , rcv_shipment_lines rsl
1623: , mtl_system_items msi
1624: , po_lines pol

Line 2001: , rcv_supply rsup

1997: --The following columns are needed for matching in cases where no LPN is involved
1998: , rsup.to_subinventory from_subinventory_code
1999: , rsup.to_locator_id from_locator_id
2000: FROM rcv_transactions rt
2001: , rcv_supply rsup
2002: , rcv_shipment_headers rsh
2003: , rcv_shipment_lines rsl
2004: , mtl_system_items msi
2005: , po_lines pol

Line 2109: , rcv_supply rsup

2105: --The following columns are needed for matching in cases where no LPN is involved
2106: , rsup.to_subinventory from_subinventory_code
2107: , rsup.to_locator_id from_locator_id
2108: FROM rcv_transactions rt
2109: , rcv_supply rsup
2110: , rcv_shipment_headers rsh
2111: , rcv_shipment_lines rsl
2112: , po_lines pol
2113: , po_distributions pod

Line 2786: , rcv_supply rsup

2782: --The following columns are needed for matching in cases where no LPN is involved
2783: , rsup.to_subinventory from_subinventory_code
2784: , rsup.to_locator_id from_locator_id
2785: FROM rcv_transactions rt
2786: , rcv_supply rsup
2787: , rcv_shipment_headers rsh
2788: , rcv_shipment_lines rsl
2789: , mtl_system_items msi
2790: WHERE rsup.rcv_transaction_id = v_rcv_txn_id

Line 3212: print_debug('create_int_shp_rcvtxn_intf_rec: 127.6 - INV and PO patch levels are J or higher. No update to rcv_supply', 4);

3208: print_debug('create_int_shp_rcvtxn_intf_rec: 127 - before update_rcv_serials_supply' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
3209: END IF;
3210: ELSE
3211: IF (l_debug = 1) THEN
3212: print_debug('create_int_shp_rcvtxn_intf_rec: 127.6 - INV and PO patch levels are J or higher. No update to rcv_supply', 4);
3213: END IF;
3214: END IF; --END IF check INV and PO patch levels
3215: END LOOP;
3216:

Line 3455: , rcv_supply rsup

3451: --The following columns are needed for matching in cases where no LPN is involved
3452: , rsup.to_subinventory from_subinventory_code
3453: , rsup.to_locator_id from_locator_id
3454: FROM rcv_transactions rt
3455: , rcv_supply rsup
3456: , rcv_shipment_headers rsh
3457: , rcv_shipment_lines rsl
3458: , mtl_system_items msi
3459: WHERE rsup.rcv_transaction_id = v_rcv_txn_id

Line 3912: ,rcv_supply rsup

3908: CURSOR l_curs_rcvtxn_detail IS
3909: SELECT rsup.po_header_id po_header_id
3910: ,rsup.oe_order_header_id oe_order_header_id
3911: FROM rcv_shipment_headers rsh
3912: ,rcv_supply rsup
3913: WHERE rsh.receipt_num = p_receipt_num
3914: AND rsh.shipment_header_id = rsup.shipment_header_id
3915: AND rsup.to_organization_id = p_organization_id
3916: AND rsup.item_id = p_item_id;

Line 5362: FROM rcv_supply rs,

5358: ,rss.lot_num lot_num
5359: ,rs.secondary_quantity secondary_quantity
5360: ,msni.transaction_interface_id transaction_interface_id
5361: ,rsl.asn_line_flag asn_line_flag
5362: FROM rcv_supply rs,
5363: rcv_transactions rt,
5364: rcv_serials_supply rss,
5365: rcv_shipment_lines rsl,
5366: rcv_shipment_headers rsh,

Line 5405: FROM rcv_supply rs,

5401: ,Nvl(rls.quantity,0) lot_qty
5402: ,decode(rt.uom_code, p_rcvtxn_uom_code, 1, 2) ORDERING1
5403: ,decode(rt.uom_code, p_rcvtxn_uom_code, (p_rcvtxn_qty - rs.quantity), 0) ORDERING2
5404: ,rsl.asn_line_flag asn_line_flag
5405: FROM rcv_supply rs,
5406: rcv_transactions rt,
5407: rcv_shipment_lines rsl,
5408: rcv_lots_supply rls,
5409: rcv_shipment_headers rsh