[Home] [Help]
498: IF nvl(v_lcm_enabled_org, 'N') = 'Y' THEN
499:
500: SELECT LCM_SHIPMENT_LINE_ID, UNIT_LANDED_COST
501: INTO v_lcm_ship_line_id, v_unit_landed_cost
502: FROM rcv_shipment_lines
503: WHERE shipment_line_id = l_shipment_line_id;
504:
505: UPDATE rcv_transactions_interface
506: SET lcm_shipment_line_id = v_lcm_ship_line_id,
903:
904: NULL;
905: END;
906:
907: -- Get the transfer_cost_group_id from rcv_shipment_lines
908: BEGIN
909: SELECT cost_group_id
910: INTO p_rcv_transaction_rec.transfer_cost_group_id
911: FROM rcv_shipment_lines
907: -- Get the transfer_cost_group_id from rcv_shipment_lines
908: BEGIN
909: SELECT cost_group_id
910: INTO p_rcv_transaction_rec.transfer_cost_group_id
911: FROM rcv_shipment_lines
912: WHERE shipment_line_id = p_rcv_rcvtxn_rec.shipment_line_id;
913: EXCEPTION
914: WHEN OTHERS THEN
915: IF (l_debug = 1) THEN
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:
1261: IF (l_debug = 1) THEN
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
1626: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
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
2007: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
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
2115: AND rsup.to_organization_id = p_organization_id
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
2792: AND rsup.to_organization_id = p_organization_id
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
3461: AND rsup.to_organization_id = p_organization_id
4890: l_progress := '40';
4891:
4892: SELECT shipment_header_id
4893: INTO l_shipment_header_id
4894: FROM rcv_shipment_lines
4895: WHERE shipment_line_id = p_reference_id;
4896:
4897: l_progress := '50';
4898: create_int_shp_rcvtxn_intf_rec(
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,
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.
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
5410: WHERE rs.item_id = p_item_id
5411: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.