APPS.CTO_BOM_RTG_PK dependencies on BOM_CTO_SRC_ORGS_B

Line 399: from bom_cto_src_orgs bcso, bom_cto_order_lines bcol, mtl_parameters mp

395: bcso.config_item_id,
396: bcso.group_reference_id
397: -- bcso.cost_rollup, bug 3877317 column will be queried in the cursor
398: -- bcso.organization_type bug 3877317 column will be queried in the cursor
399: from bom_cto_src_orgs bcso, bom_cto_order_lines bcol, mtl_parameters mp
400: where bcso.line_id = pLineId
401: and bcso.model_item_id = pModelId
402: and bcso.config_item_id is not null
403: and bcso.line_id = bcol.line_id

Line 2571: update bom_cto_src_orgs_b

2567:
2568: lStmtNum := 60;
2569:
2570: if( p_group_reference_id is null ) then
2571: update bom_cto_src_orgs_b
2572: set cost_rollup = 'N'
2573: where line_id = pLineId
2574: and organization_id = p_organization_id ;
2575:

Line 2664: update bom_cto_src_orgs_b

2660:
2661: lStmtNum := 60;
2662:
2663: if( p_group_reference_id is null ) then
2664: update bom_cto_src_orgs_b
2665: set cost_rollup = 'N'
2666: where line_id = pLineId
2667: and organization_id = p_organization_id ;
2668:

Line 2765: update bom_cto_src_orgs_b

2761: lStmtNum := 70;
2762:
2763:
2764: if( p_group_reference_id is null ) then
2765: update bom_cto_src_orgs_b
2766: set cost_rollup = 'N'
2767: where line_id = pLineId
2768: and organization_id = p_organization_id ;
2769:

Line 2819: update bom_cto_src_orgs_b

2815: lStmtNum := 75;
2816:
2817:
2818: if( p_group_reference_id is null ) then
2819: update bom_cto_src_orgs_b
2820: set cost_rollup = 'N'
2821: where line_id = pLineId
2822: and organization_id = p_organization_id ;
2823: