[Home] [Help]
1252:
1253:
1254: SELECT nvl(rsh.asn_type, 'NNN')
1255: INTO l_asn_line_flag
1256: FROM rcv_shipment_headers rsh,
1257: rcv_shipment_lines rsl
1258: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1259: AND rsl.shipment_line_id = p_rcv_rcvtxn_rec.shipment_line_id;
1260:
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
1625: , po_distributions pod
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
2006: , po_distributions pod
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
2114: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
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
2791: AND rsup.shipment_line_id = v_shipment_line_id
2846:
2847: -- default some header level variables based on the header id passed
2848: SELECT asn_type
2849: INTO l_asn_type
2850: FROM rcv_shipment_headers
2851: WHERE shipment_header_id = p_shipment_header_id;
2852:
2853: -- If l_asn_type is NULL then this shipment is not from ASN
2854: IF l_asn_type IS NOT NULL THEN
2860: ELSE
2861: -- Not an ASN shipment.
2862: SELECT receipt_source_code
2863: INTO l_source_code
2864: FROM rcv_shipment_headers
2865: WHERE shipment_header_id = p_shipment_header_id;
2866:
2867: IF l_source_code = 'VENDOR' THEN
2868: l_source_type := 'VENDOR';
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
3460: AND rsup.oe_order_line_id = v_order_line_id
3907: -- of using the view.
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
5362: FROM rcv_supply rs,
5363: rcv_transactions rt,
5364: rcv_serials_supply rss,
5365: rcv_shipment_lines rsl,
5366: rcv_shipment_headers rsh,
5367: mtl_serial_numbers_interface msni
5368: WHERE rs.item_id = p_item_id
5369: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5370: AND (p_revision is null or rs.item_revision = p_revision)
5405: FROM rcv_supply rs,
5406: rcv_transactions rt,
5407: rcv_shipment_lines rsl,
5408: rcv_lots_supply rls,
5409: rcv_shipment_headers rsh
5410: WHERE rs.item_id = p_item_id
5411: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5412: AND (p_revision is null or rs.item_revision = p_revision)
5413: AND rs.to_organization_id = p_organization_id