[Home] [Help]
35: ato_line_id number ,
36: link_to_line_id number ,
37: inventory_item_id oe_order_lines.inventory_item_id%type ,
38: item_type_code oe_order_lines.item_type_code%type ,
39: wip_supply_type bom_inventory_components.wip_supply_type%type ,
40: bom_item_type mtl_system_items.bom_item_type%type ,
41: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
42: pick_components_flag mtl_system_items.pick_components_flag%type ,
43: base_item_id mtl_system_items.base_item_id%type ,
87: line_id number ,
88: link_to_line_id number ,
89: ato_line_id number ,
90: item_type_code oe_order_lines.item_type_code%type ,
91: wip_supply_type bom_inventory_components.wip_supply_type%type ,
92: bom_item_type mtl_system_items.bom_item_type%type ,
93: replenish_to_order_flag mtl_system_items.replenish_to_order_flag%type ,
94: pick_components_flag mtl_system_items.pick_components_flag%type ,
95: base_item_id mtl_system_items.base_item_id%type ,
2370: BEGIN
2371: l_stmt_num := 48 ;
2372: select wip_supply_type
2373: into g_requests_tab(j).wip_supply_type
2374: from bom_inventory_components
2375: where bill_sequence_id = v_bill_sequence_id
2376: AND component_item_id = g_requests_tab(j).inventory_item_id
2377: AND rownum < 1 ;
2378:
2636: , p_orig_shipset_tracker(j).build_in_wip_flag
2637: , p_orig_shipset_tracker(j).atp_flag
2638: , p_orig_shipset_tracker(j).atp_components_flag
2639: , p_orig_shipset_tracker(j).mlmo_flag -- 2723674 : Initializing MLMO flag
2640: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI
2641: where line_id = p_shipset.identifier(j)
2642: and OEOL.component_sequence_id = BIC.component_sequence_id(+)
2643: and MSYI.inventory_item_id = p_shipset.inventory_item_id(j)
2644: and MSYI.organization_id = l_validation_org
4967: , bic.wip_supply_type
4968: into p_atp_bom.atp_check(i)
4969: , p_atp_bom.wip_supply_type(i)
4970: from bom_bill_of_materials bbom,
4971: bom_inventory_components bic
4972: where bbom.assembly_item_id = g_cto_sparse_shipset(l_link_id).Inventory_Item_Id
4973: and bbom.organization_id = g_cto_sparse_shipset(l_link_id).Sourcing_Org
4974: and bbom.alternate_bom_designator is NULL
4975: and bbom.common_bill_sequence_id = bic.bill_sequence_id
5220: bic.disable_date disable_date,
5221: bic.check_atp check_atp,
5222: bic.wip_supply_type
5223: from bom_bill_of_materials bbom,
5224: bom_inventory_components bic
5225: where bbom.assembly_item_id = g_cto_sparse_shipset(p_index).Inventory_Item_Id
5226: and bbom.organization_id = g_cto_sparse_shipset(p_index).Sourcing_Org
5227: and bbom.alternate_bom_designator is NULL
5228: and bbom.common_bill_sequence_id = bic.bill_sequence_id
5283: lStmtNum := 112;
5284: select bic.wip_supply_type
5285: into l_wip_supply_type
5286: from bom_bill_of_materials bbom,
5287: bom_inventory_components bic
5288: where bbom.assembly_item_id = g_cto_sparse_shipset(l_link_line_id).Inventory_Item_Id
5289: and bbom.organization_id = g_cto_sparse_shipset(l_link_line_id).Sourcing_Org
5290: and bbom.alternate_bom_designator is NULL
5291: and bbom.common_bill_sequence_id = bic.bill_sequence_id
6843: v_source_type number;
6844:
6845: cursor inven_comp is
6846: SELECT component_item_id,component_quantity
6847: FROM bom_inventory_components bic,
6848: bom_bill_of_materials bom,
6849: mtl_system_items mtl
6850: WHERE bom.assembly_item_id = p_item_id
6851: AND bom.organization_id = x_source_org
7009: gloginid, -- Last_update_login
7010: null, -- Program_application_id
7011: sysdate
7012: From
7013: bom_inventory_components bic,
7014: bom_bill_of_materials bom,
7015: mtl_system_items mtl
7016: where bom.assembly_item_id = p_item_id
7017: and bom.organization_id = p_org_id
7058: sysdate, -- Last_updated_date
7059: gloginid, -- Last_update_login
7060: null, -- Program_application_id
7061: sysdate
7062: from bom_inventory_components bic,
7063: bom_bill_of_materials bom,
7064: mtl_system_items mtl
7065: where bom.assembly_item_id = p_item_id
7066: and bom.organization_id = p_org_id
7070: select
7071: bic2.component_item_id
7072: from bom_bill_of_materials bom1,
7073: bom_bill_of_materials bom2,
7074: bom_inventory_components bic1,
7075: bom_inventory_components bic2
7076: where bom1.assembly_item_id = p_item_id
7077: and bom1.organization_id = p_org_id
7078: and bom1.bill_sequence_id = bic1.bill_sequence_id
7071: bic2.component_item_id
7072: from bom_bill_of_materials bom1,
7073: bom_bill_of_materials bom2,
7074: bom_inventory_components bic1,
7075: bom_inventory_components bic2
7076: where bom1.assembly_item_id = p_item_id
7077: and bom1.organization_id = p_org_id
7078: and bom1.bill_sequence_id = bic1.bill_sequence_id
7079: and bic1.bom_item_type in(1, 2)
7104:
7105: cursor atoitem is
7106: select component_item_id
7107: from bom_bill_of_materials bom,
7108: bom_inventory_components bic,
7109: mtl_system_items mtl
7110: where bom.assembly_item_id = p_item_id
7111: and bom.organization_id = p_org_id
7112: and bom.bill_sequence_id = bic.bill_sequence_id