DBA Data[Home] [Help]

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 2631: update bom_cto_src_orgs_b

2627:
2628: lStmtNum := 60;
2629:
2630: if( p_group_reference_id is null ) then
2631: update bom_cto_src_orgs_b
2632: set cost_rollup = 'N'
2633: where line_id = pLineId
2634: and organization_id = p_organization_id ;
2635:

Line 2724: update bom_cto_src_orgs_b

2720:
2721: lStmtNum := 60;
2722:
2723: if( p_group_reference_id is null ) then
2724: update bom_cto_src_orgs_b
2725: set cost_rollup = 'N'
2726: where line_id = pLineId
2727: and organization_id = p_organization_id ;
2728:

Line 2825: update bom_cto_src_orgs_b

2821: lStmtNum := 70;
2822:
2823:
2824: if( p_group_reference_id is null ) then
2825: update bom_cto_src_orgs_b
2826: set cost_rollup = 'N'
2827: where line_id = pLineId
2828: and organization_id = p_organization_id ;
2829:

Line 2879: update bom_cto_src_orgs_b

2875: lStmtNum := 75;
2876:
2877:
2878: if( p_group_reference_id is null ) then
2879: update bom_cto_src_orgs_b
2880: set cost_rollup = 'N'
2881: where line_id = pLineId
2882: and organization_id = p_organization_id ;
2883: