DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 261: FROM mtl_system_items

257: INTO l_ship_order_line_rec.serial_code,
258: l_ship_order_line_rec.inv_item_id ,
259: l_ship_order_line_rec.inv_org_id,
260: l_ship_order_line_rec.bom_item_type
261: FROM mtl_system_items
262: WHERE inventory_item_id = l_u_instance_rec.inventory_item_id
263: AND organization_id = l_order_line_rec.ship_from_org_id;
264:
265: EXCEPTION

Line 1367: FROM mtl_system_items msi

1363: debug(l_lpad_string||'lvl_'||l_lvl||'_line_id : '||l_line_tbl(l_ind).line_id);
1364:
1365: SELECT nvl(msi.comms_nl_trackable_flag,'N')
1366: INTO l_ib_trackable_flag
1367: FROM mtl_system_items msi
1368: WHERE msi.inventory_item_id = l_line_tbl(l_ind).inventory_item_id
1369: AND msi.organization_id = p_om_vld_org_id;
1370:
1371: debug(l_lpad_string||'item_type_code : '||l_line_tbl(l_ind).item_type_code);

Line 1967: FROM mtl_system_items msi

1963: WHERE line_id = l_parent_line_id;
1964:
1965: SELECT nvl(msi.comms_nl_trackable_flag, 'N')
1966: INTO l_ib_trackable_flag
1967: FROM mtl_system_items msi
1968: WHERE msi.inventory_item_id = l_inventory_item_id
1969: AND msi.organization_id = p_om_vld_org_id;
1970:
1971: IF l_ib_trackable_flag = 'Y' THEN

Line 3734: FROM mtl_system_items

3730: l_config_rec := px_config_rec;
3731:
3732: SELECT serial_number_control_code
3733: INTO l_config_rec.sub_model_serial_code
3734: FROM mtl_system_items
3735: WHERE inventory_item_id = l_config_rec.sub_config_item_id
3736: AND organization_id = l_config_rec.ship_organization_id;
3737:
3738: IF l_config_rec.sub_model_serial_code in (2, 5) THEN

Line 3838: FROM mtl_system_items

3834: IF l_config_rec.line_id is not null THEN
3835:
3836: SELECT serial_number_control_code
3837: INTO l_config_rec.serial_code
3838: FROM mtl_system_items
3839: WHERE inventory_item_id = l_config_rec.item_id
3840: AND organization_id = l_config_rec.ship_organization_id;
3841:
3842: get_job_for_config_line(

Line 4541: FROM mtl_system_items msi,

4537: x_return_status OUT NOCOPY varchar2)
4538: IS
4539: CURSOR config_cur IS
4540: SELECT msi.serial_number_control_code
4541: FROM mtl_system_items msi,
4542: oe_order_lines_all oel
4543: WHERE oel.link_to_line_id = p_ato_line_id
4544: AND oel.item_type_code = 'CONFIG'
4545: AND msi.organization_id = oel.ship_from_org_id

Line 5553: FROM mtl_system_items

5549: debug('Child Item is involved in wip transaction, so trying to break relation with config');
5550:
5551: SELECT serial_number_control_code
5552: INTO l_option_serial_code
5553: FROM mtl_system_items
5554: WHERE inventory_item_id = l_child_line_tbl(cl_ind).inventory_item_id
5555: AND organization_id = l_child_line_tbl(cl_ind).ship_from_org_id;
5556:
5557: l_ii_rltns_tbl := l_temp_ii_rltns_tbl;

Line 6428: FROM mtl_system_items

6424: BEGIN
6425:
6426: SELECT serial_number_control_code
6427: INTO l_option_serial_code
6428: FROM mtl_system_items
6429: WHERE inventory_item_id = p_order_line_rec.inventory_item_id
6430: AND organization_id = p_order_line_rec.ship_from_org_id;
6431:
6432: END;

Line 6815: FROM mtl_system_items

6811: l_csi_txn_rec.transaction_status_code := 'PENDING';
6812:
6813: SELECT serial_number_control_code
6814: INTO l_option_serial_code
6815: FROM mtl_system_items
6816: WHERE inventory_item_id = p_order_line_rec.inventory_item_id
6817: AND organization_id = p_order_line_rec.ship_from_org_id;
6818:
6819: get_wip_instances(

Line 8581: FROM MTL_SYSTEM_ITEMS_B

8577: -- then we need to update the Order line ID for the Item Instance.
8578: --
8579: SELECT nvl(shippable_item_flag ,'N')
8580: INTO l_shippable_item_flag
8581: FROM MTL_SYSTEM_ITEMS_B
8582: WHERE inventory_item_id = l_order_line_rec.inventory_item_id
8583: AND organization_id = l_order_line_rec.ship_from_org_id;
8584: --
8585: IF l_shippable_item_flag = 'Y' THEN

Line 8693: FROM mtl_system_items

8689: l_bom_item_type,
8690: l_reservable_type,
8691: l_pick_components_flag,
8692: l_primary_uom_code
8693: FROM mtl_system_items
8694: WHERE inventory_item_id = l_order_line_rec.inventory_item_id
8695: AND organization_id = l_order_line_rec.ship_from_org_id;
8696:
8697: debug(' serial_code : '||l_serial_code);

Line 9917: mtl_system_items msi,

9913: to_char(null) ib_current_loc,
9914: to_number(null) ib_current_loc_id
9915: FROM oe_order_headers_all ooh,
9916: oe_order_lines_all ool,
9917: mtl_system_items msi,
9918: mtl_unit_transactions mut,
9919: mtl_material_transactions mmt,
9920: mtl_secondary_inventories msei,
9921: hr_all_organization_units haou

Line 9975: mtl_system_items msi,

9971: to_char(null) ib_current_loc,
9972: to_number(null) ib_current_loc_id
9973: FROM oe_order_headers_all ooh,
9974: oe_order_lines_all ool,
9975: mtl_system_items msi,
9976: mtl_unit_transactions mut,
9977: mtl_transaction_lot_numbers mtln,
9978: mtl_material_transactions mmt,
9979: mtl_secondary_inventories msei,

Line 10056: FROM mtl_system_items

10052: l_lot_code,
10053: l_revision_control_code,
10054: l_locator_control_code,
10055: l_ib_trackable_flag
10056: FROM mtl_system_items
10057: WHERE inventory_item_id = l_order_line_rec.inv_item_id
10058: AND organization_id = l_ship_from_org_id;
10059:
10060: debug(' serial_control_code :'||l_serial_code);