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_MSUTIL_PUB dependencies on BOM_PARAMETERS

Line 456: ( select 1 from bom_parameters

452: update bom_cto_model_orgs set create_bom = 'Y'
453: where group_reference_id = v_group_reference_id and organization_id = v_orgs_list(i)
454: -- bugfix 4274446 : Check create_config_bom parameter
455: and exists
456: ( select 1 from bom_parameters
457: where organization_id = v_orgs_list(i)
458: and nvl(create_config_bom,'N') = 'Y' );
459:
460: oe_debug_pub.add( 'UPDATED BCMO create_bom = Y for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;

Line 469: ( select 1 from bom_parameters

465: update bom_cto_src_orgs_b set create_bom = 'Y'
466: where line_id = v_model_lines.line_id and organization_id = v_orgs_list(i)
467: -- bugfix 4274446 : Check create_config_bom parameter
468: and exists
469: ( select 1 from bom_parameters
470: where organization_id = v_orgs_list(i)
471: and nvl(create_config_bom,'N') = 'Y' );
472:
473: oe_debug_pub.add( 'UPDATED BCSO create_bom = Y for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;

Line 638: and exists ( select 1 from bom_parameters bp

634: and bcol.config_creation in ( 1 , 2 )
635: and mp.organization_id = bcso_b.organization_id
636: and mp.organization_id <> mp.cost_organization_id
637: and bcso_b.create_bom = 'Y' )
638: and exists ( select 1 from bom_parameters bp
639: where bp.organization_id = bcso_b1.organization_id
640: and bp.create_config_bom = 'Y' ) ;
641:
642:

Line 1026: ( select 1 from bom_parameters

1022: update bom_cto_model_orgs set create_bom = 'Y'
1023: where group_reference_id = v_group_reference_id and organization_id = v_orgs_list(i)
1024: -- bugfix 4274446 : Check create_config_bom parameter
1025: and exists
1026: ( select 1 from bom_parameters
1027: where organization_id = v_orgs_list(i)
1028: and nvl(create_config_bom,'N') = 'Y' );
1029:
1030: oe_debug_pub.add( 'UPDATED BCMO create_bom = Y for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;

Line 1039: ( select 1 from bom_parameters

1035: update bom_cto_src_orgs_b set create_bom = 'Y'
1036: where line_id = v_model_lines.line_id and organization_id = v_orgs_list(i)
1037: -- bugfix 4274446 : Check create_config_bom parameter
1038: and exists
1039: ( select 1 from bom_parameters
1040: where organization_id = v_orgs_list(i)
1041: and nvl(create_config_bom,'N') = 'Y' );
1042:
1043: oe_debug_pub.add( 'UPDATED BCSO create_bom = Y for line id ' || v_model_lines.line_id || ' rows ' || SQL%ROWCOUNT , 1 ) ;

Line 1102: and exists ( select 1 from bom_parameters bp

1098: and bcol.config_creation in ( 1 , 2 )
1099: and mp.organization_id = bcso_b.organization_id
1100: and mp.organization_id <> mp.cost_organization_id
1101: and bcso_b.create_bom = 'Y' )
1102: and exists ( select 1 from bom_parameters bp
1103: where bp.organization_id = bcso_b1.organization_id
1104: and bp.create_config_bom = 'Y' ) ;
1105:
1106:

Line 1556: from bom_parameters bp, bom_bill_of_materials bbom

1552: gLoginId, -- last_update_login
1553: null, -- program_application_id,??
1554: null, -- program_id,??
1555: sysdate -- program_update_date
1556: from bom_parameters bp, bom_bill_of_materials bbom
1557: where bp.organization_id = pRcvOrgId
1558: and bp.organization_id = bbom.organization_id (+)
1559: and pModelItemId = bbom.assembly_item_id (+)
1560: and bbom.alternate_bom_designator is null

Line 1689: from bom_parameters bp, bom_bill_of_materials bbom

1685: gLoginId, -- last_update_login
1686: null, -- program_application_id,??
1687: null, -- program_id,??
1688: sysdate -- program_update_date
1689: from bom_parameters bp, bom_bill_of_materials bbom
1690: where bp.organization_id = pRcvOrgId
1691: and bp.organization_id = bbom.organization_id (+)
1692: and pModelItemId = bbom.assembly_item_id (+)
1693: and bbom.alternate_bom_designator is null

Line 1821: from bom_parameters bp, bom_bill_of_materials bbom

1817: gLoginId, -- last_update_login
1818: null, -- program_application_id,??
1819: null, -- program_id,??
1820: sysdate -- program_update_date
1821: from bom_parameters bp, bom_bill_of_materials bbom
1822: where bp.organization_id = pRcvOrgId
1823: and bp.organization_id = bbom.organization_id (+)
1824: and pModelItemId = bbom.assembly_item_id (+)
1825: and bbom.alternate_bom_designator is null

Line 2272: from bom_parameters bp

2268: gLoginId, -- last_update_login
2269: null, -- program_application_id,??
2270: null, -- program_id,??
2271: sysdate -- program_update_date
2272: from bom_parameters bp
2273: where bp.organization_id = l_curr_src_org
2274: and NOT EXISTS /* NOT EXISTS should be there to check whether same org is reached thru other paths */
2275: (select NULL
2276: from bom_cto_src_orgs_b

Line 2370: from bom_parameters bp

2366: gLoginId, -- last_update_login
2367: null, -- program_application_id,??
2368: null, -- program_id,??
2369: sysdate -- program_update_date
2370: from bom_parameters bp
2371: where bp.organization_id = l_curr_src_org
2372: and NOT EXISTS /* NOT EXISTS should be there to check whether same org is reached thru other paths */
2373: (select NULL
2374: from bom_cto_src_orgs_b

Line 2567: from bom_bill_of_materials bom, bom_parameters bp

2563: gLoginId, -- last_update_login
2564: null, -- program_application_id,??
2565: null, -- program_id,??
2566: sysdate -- program_update_date
2567: from bom_bill_of_materials bom, bom_parameters bp
2568: where p_organization_id = bp.organization_id
2569: and p_model_item_id = bom.assembly_item_id(+)
2570: and bp.organization_id = bom.organization_id(+)
2571: and bom.alternate_bom_designator is null

Line 4259: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp

4255: gLoginId, -- last_update_login
4256: null, -- program_application_id,??
4257: null, -- program_id,??
4258: sysdate -- program_update_date
4259: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4260: where msi.inventory_item_id = p_model_item_id
4261: and msi.inventory_item_id = bom.assembly_item_id(+)
4262: and msi.organization_id = bom.organization_id(+)
4263: and bom.alternate_bom_designator is null

Line 4339: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp

4335: gLoginId, -- last_update_login
4336: null, -- program_application_id,??
4337: null, -- program_id,??
4338: sysdate -- program_update_date
4339: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4340: where msi.inventory_item_id = p_model_item_id
4341: and msi.inventory_item_id = bom.assembly_item_id(+)
4342: and msi.organization_id = bom.organization_id(+)
4343: and bom.alternate_bom_designator is null

Line 4488: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp

4484: gLoginId, -- last_update_login
4485: null, -- program_application_id,??
4486: null, -- program_id,??
4487: sysdate -- program_update_date
4488: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4489: where msi.inventory_item_id = p_model_item_id
4490: and msi.inventory_item_id = bom.assembly_item_id(+)
4491: and msi.organization_id = bom.organization_id(+)
4492: and bom.alternate_bom_designator is null

Line 5153: ( select * from bom_parameters bp, bom_bill_of_materials bbom

5149: and model_item_id = p_model_item_id
5150: and organization_id = v_receiving_org
5151: and rcv_org_id = v_receiving_org
5152: and exists
5153: ( select * from bom_parameters bp, bom_bill_of_materials bbom
5154: where bp.organization_id = v_receiving_org
5155: and bbom.organization_id = bp.organization_id
5156: and bbom.assembly_item_id = p_model_item_id
5157: and bp.create_config_bom = 'Y' ) ;

Line 5185: from bom_parameters bp, bom_bill_of_materials bbom

5181: where line_id = p_line_id
5182: and model_item_id = p_model_item_id
5183: and rcv_org_id in (
5184: select bp.organization_id
5185: from bom_parameters bp, bom_bill_of_materials bbom
5186: where bbom.organization_id = bp.organization_id
5187: and bbom.assembly_item_id = p_model_item_id
5188: and bp.create_config_bom = 'Y' )
5189: and rownum = 1 ;