APPS.CTO_MSUTIL_PUB dependencies on BOM_CTO_ORDER_LINES_UPG

Line 743: from bom_cto_order_lines_upg

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

Line 752: bom_cto_order_lines_upg bcol

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

Line 770: from bom_cto_order_lines_upg

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

Line 781: v_config_creation bom_cto_order_lines_upg.config_creation%type ;

777:
778: v_current_model_line_id number ;
779: v_current_model_item_id number ;
780: v_current_config_item_id number;
781: v_config_creation bom_cto_order_lines_upg.config_creation%type ;
782:
783:
784: v_group_reference_id number ;
785: v_orgs_list cto_oss_source_pk.orgs_list ;

Line 828: from bom_cto_order_lines_upg

824:
825: lStmtNumber := 40;
826: select ship_from_org_id
827: into lShipFromOrgId
828: from bom_cto_order_lines_upg
829: where line_id = v_model_lines.line_id;
830:
831: lStmtNumber := 50;
832: IF PG_DEBUG <> 0 THEN

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

1991: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines
1992: where line_id = p_line_id ;
1993:
1994: else
1995: select nvl( option_specific , 'N' ) into v_option_specific from bom_cto_order_lines_upg
1996: where line_id = p_line_id ;
1997:
1998: end if ;
1999:

Line 5168: from bom_cto_order_lines_upg

5164: select inventory_item_id,
5165: nvl(config_creation,1)
5166: into xModelItemId,
5167: l_config_creation
5168: from bom_cto_order_lines_upg
5169: where line_id=pModelLineId;
5170:
5171: ELSE
5172: