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 910: mtl_System_items_kfv msi,

906: nvl(bic.basis_type,1), /* LBM Project */
907: bic.wip_supply_type --4645636
908: from bom_inventory_components bic,
909: bom_bill_of_materials bom,
910: mtl_System_items_kfv msi,
911: --mtl_system_items msi,
912: bom_operational_routings bor,
913: wip_lines wil
914: --bugfix 4615409

Line 911: --mtl_system_items msi,

907: bic.wip_supply_type --4645636
908: from bom_inventory_components bic,
909: bom_bill_of_materials bom,
910: mtl_System_items_kfv msi,
911: --mtl_system_items msi,
912: bom_operational_routings bor,
913: wip_lines wil
914: --bugfix 4615409
915: --bom_operational_routings bor_p,--parent

Line 953: mtl_System_items_kfv msi,

949: nvl(bic.basis_type,1),/* LBM Project */
950: bic.wip_supply_type --4645636
951: from bom_inventory_components bic,
952: bom_bill_of_materials bom,
953: mtl_System_items_kfv msi,
954: --mtl_System_items_b msi,
955: bom_operational_routings bor,
956: wip_lines wil
957: --bugfix 4615409

Line 954: --mtl_System_items_b msi,

950: bic.wip_supply_type --4645636
951: from bom_inventory_components bic,
952: bom_bill_of_materials bom,
953: mtl_System_items_kfv msi,
954: --mtl_System_items_b msi,
955: bom_operational_routings bor,
956: wip_lines wil
957: --bugfix 4615409
958: --bom_operational_routings bor_p,--parent

Line 2017: l_item_id mtl_system_items_kfv.inventory_item_id%type;

2013: l_parent_start_date DATE ;
2014: l_child_item_id NUMBER :=0 ;
2015: l_child_qty Number :=0;
2016:
2017: l_item_id mtl_system_items_kfv.inventory_item_id%type;
2018: l_ship_org mtl_system_items_kfv.organization_id%type;
2019: l_schedule_ship_date date ;
2020: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2021: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;

Line 2018: l_ship_org mtl_system_items_kfv.organization_id%type;

2014: l_child_item_id NUMBER :=0 ;
2015: l_child_qty Number :=0;
2016:
2017: l_item_id mtl_system_items_kfv.inventory_item_id%type;
2018: l_ship_org mtl_system_items_kfv.organization_id%type;
2019: l_schedule_ship_date date ;
2020: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2021: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2022: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;

Line 2020: l_item_name mtl_system_items_kfv.concatenated_segments%type;

2016:
2017: l_item_id mtl_system_items_kfv.inventory_item_id%type;
2018: l_ship_org mtl_system_items_kfv.organization_id%type;
2019: l_schedule_ship_date date ;
2020: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2021: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2022: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;
2023: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;
2024: l_ordered_uom varchar2(3) := null;

Line 2021: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;

2017: l_item_id mtl_system_items_kfv.inventory_item_id%type;
2018: l_ship_org mtl_system_items_kfv.organization_id%type;
2019: l_schedule_ship_date date ;
2020: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2021: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2022: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;
2023: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;
2024: l_ordered_uom varchar2(3) := null;
2025: l_order_number number := null;

Line 2022: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;

2018: l_ship_org mtl_system_items_kfv.organization_id%type;
2019: l_schedule_ship_date date ;
2020: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2021: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2022: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;
2023: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;
2024: l_ordered_uom varchar2(3) := null;
2025: l_order_number number := null;
2026: l_cfm_routing_flag number := null;

Line 2023: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;

2019: l_schedule_ship_date date ;
2020: l_item_name mtl_system_items_kfv.concatenated_segments%type;
2021: l_fixed_lead_time mtl_system_items_kfv.fixed_lead_time%type;
2022: l_variable_lead_time mtl_system_items_kfv.variable_lead_time%type;
2023: l_processing_lead_time mtl_system_items_kfv.full_lead_time%type;
2024: l_ordered_uom varchar2(3) := null;
2025: l_order_number number := null;
2026: l_cfm_routing_flag number := null;
2027: l_ordered_quantity number := null;

Line 2157: mtl_system_items_kfv mtl,

2153: l_cfm_routing_flag,
2154: l_routing_sequence_id
2155: FROM oe_order_lines_all oel,
2156: oe_order_headers_all oeh,
2157: mtl_system_items_kfv mtl,
2158: bom_operational_routings bor
2159: WHERE oel.line_id = p_Top_Assembly_LineId
2160: AND oeh.header_id = oel.header_id
2161: AND oel.inventory_item_id = mtl.inventory_item_id

Line 3448: mtl_system_items msi

3444:
3445: from bom_calendar_dates cal,
3446: mtl_parameters mp,
3447: wip_parameters wp,
3448: mtl_system_items msi
3449: where mp.organization_id = l_ship_org
3450: and wp.organization_id = mp.organization_id
3451: and msi.organization_id = l_ship_org
3452: and msi.inventory_item_id = l_mlsupply_items(l_index).item_id --inventory item id

Line 3596: mtl_system_items msi

3592: null)
3593: from bom_calendar_dates cal,
3594: mtl_parameters mp,
3595: wip_parameters wp,
3596: mtl_system_items msi
3597: where mp.organization_id = l_ship_org
3598: and wp.organization_id = mp.organization_id
3599: and msi.organization_id = l_ship_org
3600: and msi.inventory_item_id = l_mlsupply_items(l_index).item_id --inventory item id