eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_BOM_RTG_PK dependencies on BOM_CTO_SRC_ORGS

Line 87: * RCV_ORG_ID and ORGANIZATION_ID columns in bom_cto_src_orgs view.

83: * BUG 3877317.
84: *
85: * old_behavior:
86: * Organizations where Cost rollup needs to be performed were determined using
87: * RCV_ORG_ID and ORGANIZATION_ID columns in bom_cto_src_orgs view.
88: *
89: * new behavior:
90: * Organizations where cost rollup needs to be performed will now be determined using
91: * only ORGANIZATION_ID column in bom_cto_src_orgs view.

Line 91: * only ORGANIZATION_ID column in bom_cto_src_orgs view.

87: * RCV_ORG_ID and ORGANIZATION_ID columns in bom_cto_src_orgs view.
88: *
89: * new behavior:
90: * Organizations where cost rollup needs to be performed will now be determined using
91: * only ORGANIZATION_ID column in bom_cto_src_orgs view.
92: *
93: * procedure CREATE_IN_SRC_ORGS has changed
94: *
95: * 1) change to cursor cSrcOrgs

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 470: v_create_bom bom_cto_src_orgs.create_bom%type := null ; -- bug 3877317

466:
467: /* bug 3877317
468: added new variables v_create_bom, v_perform_cost_rollup
469: */
470: v_create_bom bom_cto_src_orgs.create_bom%type := null ; -- bug 3877317
471: v_perform_cost_rollup bom_cto_src_orgs.cost_rollup%type := null ; -- bug 3877317
472:
473: l_ato_line_id number;
474: l_header_id number;

Line 471: v_perform_cost_rollup bom_cto_src_orgs.cost_rollup%type := null ; -- bug 3877317

467: /* bug 3877317
468: added new variables v_create_bom, v_perform_cost_rollup
469: */
470: v_create_bom bom_cto_src_orgs.create_bom%type := null ; -- bug 3877317
471: v_perform_cost_rollup bom_cto_src_orgs.cost_rollup%type := null ; -- bug 3877317
472:
473: l_ato_line_id number;
474: l_header_id number;
475: lEstRelDate Date;

Line 550: where exists ( select * from bom_cto_src_orgs

546:
547: begin
548:
549: select 'Y' into v_perform_cost_rollup from dual
550: where exists ( select * from bom_cto_src_orgs
551: where line_id = pLineId
552: and cost_rollup = 'Y'
553: and organization_id = lNextRec.cost_organization_id ) ;
554:

Line 575: where exists ( select * from bom_cto_src_orgs

571:
572: begin
573:
574: select 'Y' into v_create_bom from dual
575: where exists ( select * from bom_cto_src_orgs
576: where line_id = pLineId
577: and create_bom = 'Y'
578: and organization_id = lNextRec.organization_id ) ;
579:

Line 2202: v_organization_type bom_cto_src_orgs.organization_type%type := null ;

2198: v_cto_cost_xudc cst_item_costs.item_cost%type := null ;
2199: v_valuation_cost cst_item_costs.item_cost%type := null ;
2200: v_buy_cost cst_item_costs.item_cost%type := null ;
2201:
2202: v_organization_type bom_cto_src_orgs.organization_type%type := null ;
2203:
2204: v_cto_cost_type_id cst_item_costs.cost_type_id%type ;
2205: v_buy_cost_type_id cst_item_costs.cost_type_id%type ;
2206: v_rolledup_cost_count number ;

Line 2499: from bom_cto_src_orgs

2495: added new too_many_rows exception handler due to query being dependent only on organization_id
2496: */
2497: begin
2498: select nvl( organization_type , 1 ) into v_organization_type
2499: from bom_cto_src_orgs
2500: where line_id = pLineId
2501: and cost_rollup = 'Y'
2502: and organization_id = p_organization_id ; -- added for bug 3877317 copied from fp.
2503: -- In 11.5.10 there could be multiple manufacturing orgs.

Line 2523: from bom_cto_src_orgs

2519: */
2520:
2521: begin
2522: select organization_type into v_organization_type
2523: from bom_cto_src_orgs
2524: where line_id = pLineId
2525: and rcv_org_id = p_organization_id
2526: and organization_id = p_organization_id
2527: and organization_type = '2'

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: