APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on MTL_SYSTEM_ITEMS_KFV

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 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 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