APPS.INV_RCV_STD_DELIVER_APIS dependencies on RCV_SUPPLY

Line 1654: , rcv_supply rsup

1650: --The following columns are needed for matching in cases where no LPN is involved
1651: , rsup.to_subinventory from_subinventory_code
1652: , rsup.to_locator_id from_locator_id
1653: FROM rcv_transactions rt
1654: , rcv_supply rsup
1655: , rcv_shipment_headers rsh
1656: , rcv_shipment_lines rsl
1657: , mtl_system_items msi
1658: , po_lines pol

Line 2035: , rcv_supply rsup

2031: --The following columns are needed for matching in cases where no LPN is involved
2032: , rsup.to_subinventory from_subinventory_code
2033: , rsup.to_locator_id from_locator_id
2034: FROM rcv_transactions rt
2035: , rcv_supply rsup
2036: , rcv_shipment_headers rsh
2037: , rcv_shipment_lines rsl
2038: , mtl_system_items msi
2039: , po_lines pol

Line 2143: , rcv_supply rsup

2139: --The following columns are needed for matching in cases where no LPN is involved
2140: , rsup.to_subinventory from_subinventory_code
2141: , rsup.to_locator_id from_locator_id
2142: FROM rcv_transactions rt
2143: , rcv_supply rsup
2144: , rcv_shipment_headers rsh
2145: , rcv_shipment_lines rsl
2146: , po_lines pol
2147: , po_distributions pod

Line 2820: , rcv_supply rsup

2816: --The following columns are needed for matching in cases where no LPN is involved
2817: , rsup.to_subinventory from_subinventory_code
2818: , rsup.to_locator_id from_locator_id
2819: FROM rcv_transactions rt
2820: , rcv_supply rsup
2821: , rcv_shipment_headers rsh
2822: , rcv_shipment_lines rsl
2823: , mtl_system_items msi
2824: WHERE rsup.rcv_transaction_id = v_rcv_txn_id

Line 3308: 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);

3304: print_debug('create_int_shp_rcvtxn_intf_rec: 127 - before update_rcv_serials_supply' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
3305: END IF;
3306: ELSE
3307: IF (l_debug = 1) THEN
3308: 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);
3309: END IF;
3310: END IF; --END IF check INV and PO patch levels
3311: END LOOP;
3312:

Line 3551: , rcv_supply rsup

3547: --The following columns are needed for matching in cases where no LPN is involved
3548: , rsup.to_subinventory from_subinventory_code
3549: , rsup.to_locator_id from_locator_id
3550: FROM rcv_transactions rt
3551: , rcv_supply rsup
3552: , rcv_shipment_headers rsh
3553: , rcv_shipment_lines rsl
3554: , mtl_system_items msi
3555: WHERE rsup.rcv_transaction_id = v_rcv_txn_id

Line 4026: ,rcv_supply rsup

4022: CURSOR l_curs_rcvtxn_detail IS
4023: SELECT rsup.po_header_id po_header_id
4024: ,rsup.oe_order_header_id oe_order_header_id
4025: FROM rcv_shipment_headers rsh
4026: ,rcv_supply rsup
4027: WHERE rsh.receipt_num = p_receipt_num
4028: AND rsh.shipment_header_id = rsup.shipment_header_id
4029: AND rsup.to_organization_id = p_organization_id
4030: AND rsup.item_id = p_item_id

Line 5484: FROM rcv_supply rs,

5480: ,rss.lot_num lot_num
5481: ,rs.secondary_quantity secondary_quantity
5482: ,msni.transaction_interface_id transaction_interface_id
5483: ,rsl.asn_line_flag asn_line_flag
5484: FROM rcv_supply rs,
5485: rcv_transactions rt,
5486: rcv_serials_supply rss,
5487: rcv_shipment_lines rsl,
5488: rcv_shipment_headers rsh,

Line 5527: FROM rcv_supply rs,

5523: ,Nvl(rls.quantity,0) lot_qty
5524: ,decode(rt.uom_code, p_rcvtxn_uom_code, 1, 2) ORDERING1
5525: ,decode(rt.uom_code, p_rcvtxn_uom_code, (p_rcvtxn_qty - rs.quantity), 0) ORDERING2
5526: ,rsl.asn_line_flag asn_line_flag
5527: FROM rcv_supply rs,
5528: rcv_transactions rt,
5529: rcv_shipment_lines rsl,
5530: rcv_lots_supply rls,
5531: rcv_shipment_headers rsh