eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ORDER_FULFILL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 284: FROM mtl_system_items

280: INTO l_ship_order_line_rec.serial_code,
281: l_ship_order_line_rec.inv_item_id ,
282: l_ship_order_line_rec.inv_org_id,
283: l_ship_order_line_rec.bom_item_type
284: FROM mtl_system_items
285: WHERE inventory_item_id = l_u_instance_rec.inventory_item_id
286: AND organization_id = l_order_line_rec.ship_from_org_id;
287:
288: EXCEPTION

Line 1407: FROM mtl_system_items msi

1403: debug(l_lpad_string||'lvl_'||l_lvl||'_line_id : '||l_line_tbl(l_ind).line_id);
1404:
1405: SELECT nvl(msi.comms_nl_trackable_flag,'N')
1406: INTO l_ib_trackable_flag
1407: FROM mtl_system_items msi
1408: WHERE msi.inventory_item_id = l_line_tbl(l_ind).inventory_item_id
1409: AND msi.organization_id = p_om_vld_org_id;
1410:
1411: debug(l_lpad_string||'item_type_code : '||l_line_tbl(l_ind).item_type_code);

Line 2007: FROM mtl_system_items msi

2003: WHERE line_id = l_parent_line_id;
2004:
2005: SELECT nvl(msi.comms_nl_trackable_flag, 'N')
2006: INTO l_ib_trackable_flag
2007: FROM mtl_system_items msi
2008: WHERE msi.inventory_item_id = l_inventory_item_id
2009: AND msi.organization_id = p_om_vld_org_id;
2010:
2011: IF l_ib_trackable_flag = 'Y' THEN

Line 3782: FROM mtl_system_items

3778: l_config_rec := px_config_rec;
3779:
3780: SELECT serial_number_control_code
3781: INTO l_config_rec.sub_model_serial_code
3782: FROM mtl_system_items
3783: WHERE inventory_item_id = l_config_rec.sub_config_item_id
3784: AND organization_id = l_config_rec.ship_organization_id;
3785:
3786: IF l_config_rec.sub_model_serial_code in (2, 5) THEN

Line 3886: FROM mtl_system_items

3882: IF l_config_rec.line_id is not null THEN
3883:
3884: SELECT serial_number_control_code
3885: INTO l_config_rec.serial_code
3886: FROM mtl_system_items
3887: WHERE inventory_item_id = l_config_rec.item_id
3888: AND organization_id = l_config_rec.ship_organization_id;
3889:
3890: get_job_for_config_line(

Line 4589: FROM mtl_system_items msi,

4585: x_return_status OUT NOCOPY varchar2)
4586: IS
4587: CURSOR config_cur IS
4588: SELECT msi.serial_number_control_code
4589: FROM mtl_system_items msi,
4590: oe_order_lines_all oel
4591: WHERE oel.link_to_line_id = p_ato_line_id
4592: AND oel.item_type_code = 'CONFIG'
4593: AND msi.organization_id = oel.ship_from_org_id

Line 5097: FROM mtl_system_items_b msi, oe_order_lines_all eol

5093: --Changes for Bug 12568983
5094: BEGIN
5095: SELECT msi.SHIPPABLE_ITEM_FLAG
5096: INTO l_shippable_item_flag
5097: FROM mtl_system_items_b msi, oe_order_lines_all eol
5098: WHERE msi.ORGANIZATION_ID = eol.SHIP_FROM_ORG_ID
5099: AND msi.INVENTORY_ITEM_ID = p_option_item_id
5100: AND eol.LINE_ID = p_line_id;
5101: EXCEPTION

Line 5172: ,mtl_system_items msi

5168: ,mp.master_organization_id master_organization_id
5169: ,wro.quantity_issued quantity
5170: FROM bom_small_expl_temp bet
5171: ,bom_bill_of_materials bom
5172: ,mtl_system_items msi
5173: ,mtl_system_items msip
5174: ,mtl_parameters mp
5175: ,wip_requirement_operations wro
5176: WHERE bet.group_id = p_group_id

Line 5173: ,mtl_system_items msip

5169: ,wro.quantity_issued quantity
5170: FROM bom_small_expl_temp bet
5171: ,bom_bill_of_materials bom
5172: ,mtl_system_items msi
5173: ,mtl_system_items msip
5174: ,mtl_parameters mp
5175: ,wip_requirement_operations wro
5176: WHERE bet.group_id = p_group_id
5177: AND bet.plan_level > 0 -- Ignore Top Most

Line 5336: mtl_system_items msi ,

5332: msi.primary_uom_code primary_uom_code ,
5333: mp.master_organization_id master_organization_id
5334: FROM bom_small_expl_temp bet ,
5335: bom_bill_of_materials bom ,
5336: mtl_system_items msi ,
5337: mtl_system_items msip ,
5338: mtl_parameters mp
5339: WHERE bet.group_id = p_group_id
5340: AND bet.plan_level > 0 -- Ignore Top Most

Line 5337: mtl_system_items msip ,

5333: mp.master_organization_id master_organization_id
5334: FROM bom_small_expl_temp bet ,
5335: bom_bill_of_materials bom ,
5336: mtl_system_items msi ,
5337: mtl_system_items msip ,
5338: mtl_parameters mp
5339: WHERE bet.group_id = p_group_id
5340: AND bet.plan_level > 0 -- Ignore Top Most
5341: AND bet.component_item_id = msi.inventory_item_id

Line 6020: FROM mtl_system_items

6016: debug('Child Item is involved in wip transaction, so trying to break relation with config');
6017:
6018: SELECT serial_number_control_code
6019: INTO l_option_serial_code
6020: FROM mtl_system_items
6021: WHERE inventory_item_id = l_child_line_tbl(cl_ind).inventory_item_id
6022: AND organization_id = l_child_line_tbl(cl_ind).ship_from_org_id;
6023:
6024: l_ii_rltns_tbl := l_temp_ii_rltns_tbl;

Line 7198: FROM mtl_system_items

7194: BEGIN
7195:
7196: SELECT serial_number_control_code
7197: INTO l_option_serial_code
7198: FROM mtl_system_items
7199: WHERE inventory_item_id = p_order_line_rec.inventory_item_id
7200: AND organization_id = p_order_line_rec.ship_from_org_id;
7201:
7202: END;

Line 7585: FROM mtl_system_items

7581: l_csi_txn_rec.transaction_status_code := 'PENDING';
7582:
7583: SELECT serial_number_control_code
7584: INTO l_option_serial_code
7585: FROM mtl_system_items
7586: WHERE inventory_item_id = p_order_line_rec.inventory_item_id
7587: AND organization_id = p_order_line_rec.ship_from_org_id;
7588:
7589: debug('Calling get_wip_instances');

Line 8991: MTL_SYSTEM_ITEMS MSI

8987: IS
8988: CURSOR shippable_order_cur IS
8989: SELECT OOL.LINE_ID
8990: FROM OE_ORDER_LINES_ALL OOL,
8991: MTL_SYSTEM_ITEMS MSI
8992: WHERE OOL.HEADER_ID = p_header_id
8993: AND OOL.top_model_line_id = p_top_model_line_id
8994: AND OOL.FLOW_STATUS_CODE NOT IN ('CANCELLED')
8995: AND OOL.SHIPPABLE_FLAG = 'Y'

Line 9536: FROM MTL_SYSTEM_ITEMS_B

9532: -- then we need to update the Order line ID for the Item Instance.
9533: --
9534: SELECT nvl(shippable_item_flag ,'N')
9535: INTO l_shippable_item_flag
9536: FROM MTL_SYSTEM_ITEMS_B
9537: WHERE inventory_item_id = l_order_line_rec.inventory_item_id
9538: AND organization_id = l_order_line_rec.ship_from_org_id;
9539: --
9540: IF l_shippable_item_flag = 'Y' THEN

Line 9648: FROM mtl_system_items

9644: l_bom_item_type,
9645: l_reservable_type,
9646: l_pick_components_flag,
9647: l_primary_uom_code
9648: FROM mtl_system_items
9649: WHERE inventory_item_id = l_order_line_rec.inventory_item_id
9650: AND organization_id = l_order_line_rec.ship_from_org_id;
9651:
9652: debug(' serial_code : '||l_serial_code);

Line 10933: mtl_system_items msi,

10929: to_char(null) ib_current_loc,
10930: to_number(null) ib_current_loc_id
10931: FROM oe_order_headers_all ooh,
10932: oe_order_lines_all ool,
10933: mtl_system_items msi,
10934: mtl_unit_transactions mut,
10935: mtl_material_transactions mmt,
10936: mtl_secondary_inventories msei,
10937: hr_all_organization_units haou

Line 10991: mtl_system_items msi,

10987: to_char(null) ib_current_loc,
10988: to_number(null) ib_current_loc_id
10989: FROM oe_order_headers_all ooh,
10990: oe_order_lines_all ool,
10991: mtl_system_items msi,
10992: mtl_unit_transactions mut,
10993: mtl_transaction_lot_numbers mtln,
10994: mtl_material_transactions mmt,
10995: mtl_secondary_inventories msei,

Line 11072: FROM mtl_system_items

11068: l_lot_code,
11069: l_revision_control_code,
11070: l_locator_control_code,
11071: l_ib_trackable_flag
11072: FROM mtl_system_items
11073: WHERE inventory_item_id = l_order_line_rec.inv_item_id
11074: AND organization_id = l_ship_from_org_id;
11075:
11076: debug(' serial_control_code :'||l_serial_code);