APPS.CTO_MSUTIL_PUB dependencies on BOM_CTO_ORDER_LINES_UPG

Line 740: from bom_cto_order_lines_upg

736: config_creation,
737: perform_match,
738: config_item_id,
739: option_specific
740: from bom_cto_order_lines_upg
741: where ato_line_id = pTopAtoLineId
742: and bom_item_type = 1
743: and nvl(wip_supply_type,0) <> 6
744: order by plan_level;

Line 749: bom_cto_order_lines_upg bcol

745:
746: cursor c_parent_src_orgs is
747: select distinct bcso.organization_id
748: from bom_cto_src_orgs bcso,
749: bom_cto_order_lines_upg bcol
750: where bcol.line_id = lLineId
751: and bcol.parent_ato_line_id = bcso.line_id
752: and bcso.create_bom = 'Y';
753:

Line 767: from bom_cto_order_lines_upg

763:
764:
765: cursor get_each_type1_model is
766: select line_id , inventory_item_id , config_creation, config_item_id
767: from bom_cto_order_lines_upg
768: where bom_item_type = 1 and nvl(wip_supply_type, 1) <> 6
769: and ato_line_id = pTopAtoLineId order by plan_level ;
770:
771:

Line 778: v_config_creation bom_cto_order_lines_upg.config_creation%type ;

774:
775: v_current_model_line_id number ;
776: v_current_model_item_id number ;
777: v_current_config_item_id number;
778: v_config_creation bom_cto_order_lines_upg.config_creation%type ;
779:
780:
781: v_group_reference_id number ;
782: v_orgs_list cto_oss_source_pk.orgs_list ;

Line 823: from bom_cto_order_lines_upg

819:
820: lStmtNumber := 40;
821: select ship_from_org_id
822: into lShipFromOrgId
823: from bom_cto_order_lines_upg
824: where line_id = v_model_lines.line_id;
825:
826: lStmtNumber := 50;
827: IF PG_DEBUG <> 0 THEN

Line 2020: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines_upg

2016: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines
2017: where line_id = p_line_id ;
2018:
2019: else
2020: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines_upg
2021: where line_id = p_line_id ;
2022:
2023: end if ;
2024:

Line 4638: from bom_cto_order_lines_upg

4634: select inventory_item_id,
4635: nvl(config_creation,1)
4636: into xModelItemId,
4637: l_config_creation
4638: from bom_cto_order_lines_upg
4639: where line_id=pModelLineId;
4640:
4641: ELSE
4642: