[Home] [Help]
1276:
1277:
1278: SELECT nvl(rsh.asn_type, 'NNN')
1279: INTO l_asn_line_flag
1280: FROM rcv_shipment_headers rsh,
1281: rcv_shipment_lines rsl
1282: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1283: AND rsl.shipment_line_id = p_rcv_rcvtxn_rec.shipment_line_id;
1284:
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
1659: , po_distributions pod
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
2040: , po_distributions pod
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
2148: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
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
2825: AND rsup.shipment_line_id = v_shipment_line_id
2881:
2882: -- default some header level variables based on the header id passed
2883: SELECT asn_type
2884: INTO l_asn_type
2885: FROM rcv_shipment_headers
2886: WHERE shipment_header_id = p_shipment_header_id;
2887:
2888: -- If l_asn_type is NULL then this shipment is not from ASN
2889: IF l_asn_type IS NOT NULL THEN
2895: ELSE
2896: -- Not an ASN shipment.
2897: SELECT receipt_source_code
2898: INTO l_source_code
2899: FROM rcv_shipment_headers
2900: WHERE shipment_header_id = p_shipment_header_id;
2901:
2902: IF l_source_code = 'VENDOR' THEN
2903: l_source_type := 'VENDOR';
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
3556: AND rsup.oe_order_line_id = v_order_line_id
4021: -- of using the view.
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
5484: FROM rcv_supply rs,
5485: rcv_transactions rt,
5486: rcv_serials_supply rss,
5487: rcv_shipment_lines rsl,
5488: rcv_shipment_headers rsh,
5489: mtl_serial_numbers_interface msni
5490: WHERE rs.item_id = p_item_id
5491: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5492: AND (p_revision is null or rs.item_revision = p_revision)
5527: FROM rcv_supply rs,
5528: rcv_transactions rt,
5529: rcv_shipment_lines rsl,
5530: rcv_lots_supply rls,
5531: rcv_shipment_headers rsh
5532: WHERE rs.item_id = p_item_id
5533: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.
5534: AND (p_revision is null or rs.item_revision = p_revision)
5535: AND rs.to_organization_id = p_organization_id