[Home] [Help]
522: IF nvl(v_lcm_enabled_org, 'N') = 'Y' THEN
523:
524: SELECT LCM_SHIPMENT_LINE_ID, UNIT_LANDED_COST
525: INTO v_lcm_ship_line_id, v_unit_landed_cost
526: FROM rcv_shipment_lines
527: WHERE shipment_line_id = l_shipment_line_id;
528:
529: UPDATE rcv_transactions_interface
530: SET lcm_shipment_line_id = v_lcm_ship_line_id,
927:
928: NULL;
929: END;
930:
931: -- Get the transfer_cost_group_id from rcv_shipment_lines
932: BEGIN
933: SELECT cost_group_id
934: INTO p_rcv_transaction_rec.transfer_cost_group_id
935: FROM rcv_shipment_lines
931: -- Get the transfer_cost_group_id from rcv_shipment_lines
932: BEGIN
933: SELECT cost_group_id
934: INTO p_rcv_transaction_rec.transfer_cost_group_id
935: FROM rcv_shipment_lines
936: WHERE shipment_line_id = p_rcv_rcvtxn_rec.shipment_line_id;
937: EXCEPTION
938: WHEN OTHERS THEN
939: IF (l_debug = 1) THEN
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:
1285: IF (l_debug = 1) THEN
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
1660: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
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
2041: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
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
2149: AND rsup.to_organization_id = p_organization_id
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
2826: AND rsup.to_organization_id = p_organization_id
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
3557: AND rsup.to_organization_id = p_organization_id
5008: l_progress := '40';
5009:
5010: SELECT shipment_header_id
5011: INTO l_shipment_header_id
5012: FROM rcv_shipment_lines
5013: WHERE shipment_line_id = p_reference_id;
5014:
5015: l_progress := '50';
5016: create_int_shp_rcvtxn_intf_rec(
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,
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.
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
5532: WHERE rs.item_id = p_item_id
5533: --Bug 5250046: Removed the nvl and Modified the condition on item_revision.