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.CTO_SUBASSEMBLY_SUP_PK dependencies on MTL_SYSTEM_ITEMS

Line 913: mtl_System_items_kfv msi,

909: -- bic.wip_supply_type --4645636
910: nvl(bic.wip_supply_type, msi.wip_supply_type) -- Bug 9402188
911: from bom_inventory_components bic,
912: bom_bill_of_materials bom,
913: mtl_System_items_kfv msi,
914: --mtl_system_items msi,
915: bom_operational_routings bor,
916: wip_lines wil
917: --bugfix 4615409

Line 914: --mtl_system_items msi,

910: nvl(bic.wip_supply_type, msi.wip_supply_type) -- Bug 9402188
911: from bom_inventory_components bic,
912: bom_bill_of_materials bom,
913: mtl_System_items_kfv msi,
914: --mtl_system_items msi,
915: bom_operational_routings bor,
916: wip_lines wil
917: --bugfix 4615409
918: --bom_operational_routings bor_p,--parent

Line 960: mtl_System_items_kfv msi,

956: -- bic.wip_supply_type --4645636
957: nvl(bic.wip_supply_type, msi.wip_supply_type) --Bugfix 9402188
958: from bom_inventory_components bic,
959: bom_bill_of_materials bom,
960: mtl_System_items_kfv msi,
961: --mtl_System_items_b msi,
962: bom_operational_routings bor,
963: wip_lines wil
964: --bugfix 4615409

Line 961: --mtl_System_items_b msi,

957: nvl(bic.wip_supply_type, msi.wip_supply_type) --Bugfix 9402188
958: from bom_inventory_components bic,
959: bom_bill_of_materials bom,
960: mtl_System_items_kfv msi,
961: --mtl_System_items_b msi,
962: bom_operational_routings bor,
963: wip_lines wil
964: --bugfix 4615409
965: --bom_operational_routings bor_p,--parent

Line 2022: l_item_id mtl_system_items_kfv.inventory_item_id%type;

2018: l_parent_start_date DATE ;
2019: l_child_item_id NUMBER :=0 ;
2020: l_child_qty Number :=0;
2021:
2022: l_item_id mtl_system_items_kfv.inventory_item_id%type;
2023: l_ship_org mtl_system_items_kfv.organization_id%type;
2024: l_schedule_ship_date date ;
2025: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2026: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;

Line 2023: l_ship_org mtl_system_items_kfv.organization_id%type;

2019: l_child_item_id NUMBER :=0 ;
2020: l_child_qty Number :=0;
2021:
2022: l_item_id mtl_system_items_kfv.inventory_item_id%type;
2023: l_ship_org mtl_system_items_kfv.organization_id%type;
2024: l_schedule_ship_date date ;
2025: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2026: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2027: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;

Line 2025: l_item_name mtl_system_items_kfv.concatenated_segments%type;

2021:
2022: l_item_id mtl_system_items_kfv.inventory_item_id%type;
2023: l_ship_org mtl_system_items_kfv.organization_id%type;
2024: l_schedule_ship_date date ;
2025: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2026: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2027: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;
2028: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;
2029: l_ordered_uom varchar2(3) := null;

Line 2026: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;

2022: l_item_id mtl_system_items_kfv.inventory_item_id%type;
2023: l_ship_org mtl_system_items_kfv.organization_id%type;
2024: l_schedule_ship_date date ;
2025: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2026: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2027: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;
2028: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;
2029: l_ordered_uom varchar2(3) := null;
2030: l_order_number number := null;

Line 2027: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;

2023: l_ship_org mtl_system_items_kfv.organization_id%type;
2024: l_schedule_ship_date date ;
2025: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2026: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2027: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;
2028: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;
2029: l_ordered_uom varchar2(3) := null;
2030: l_order_number number := null;
2031: l_cfm_routing_flag number := null;

Line 2028: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;

2024: l_schedule_ship_date date ;
2025: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2026: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2027: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;
2028: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;
2029: l_ordered_uom varchar2(3) := null;
2030: l_order_number number := null;
2031: l_cfm_routing_flag number := null;
2032: l_ordered_quantity number := null;

Line 2165: mtl_system_items_kfv mtl,

2161: l_cfm_routing_flag,
2162: l_routing_sequence_id
2163: FROM oe_order_lines_all oel,
2164: oe_order_headers_all oeh,
2165: mtl_system_items_kfv mtl,
2166: bom_operational_routings bor
2167: WHERE oel.line_id = p_Top_Assembly_LineId
2168: AND oeh.header_id = oel.header_id
2169: AND oel.inventory_item_id = mtl.inventory_item_id

Line 3485: mtl_system_items msi

3481:
3482: from bom_calendar_dates cal,
3483: mtl_parameters mp,
3484: wip_parameters wp,
3485: mtl_system_items msi
3486: where mp.organization_id = l_ship_org
3487: and wp.organization_id = mp.organization_id
3488: and msi.organization_id = l_ship_org
3489: and msi.inventory_item_id = l_mlsupply_items(l_index).item_id --inventory item id

Line 3632: mtl_system_items msi

3628: null)
3629: from bom_calendar_dates cal,
3630: mtl_parameters mp,
3631: wip_parameters wp,
3632: mtl_system_items msi
3633: where mp.organization_id = l_ship_org
3634: and wp.organization_id = mp.organization_id
3635: and msi.organization_id = l_ship_org
3636: and msi.inventory_item_id = l_mlsupply_items(l_index).item_id --inventory item id