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 459: ( select 1 from bom_parameters

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

Line 472: ( select 1 from bom_parameters

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

Line 641: and exists ( select 1 from bom_parameters bp

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

Line 1031: ( select 1 from bom_parameters

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

Line 1044: ( select 1 from bom_parameters

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

Line 1107: and exists ( select 1 from bom_parameters bp

1103: and bcol.config_creation in ( 1 , 2 )
1104: and mp.organization_id = bcso_b.organization_id
1105: and mp.organization_id <> mp.cost_organization_id
1106: and bcso_b.create_bom = 'Y' )
1107: and exists ( select 1 from bom_parameters bp
1108: where bp.organization_id = bcso_b1.organization_id
1109: and bp.create_config_bom = 'Y' ) ;
1110:
1111:

Line 1550: from bom_parameters bp, bom_bill_of_materials bbom

1546: gLoginId, -- last_update_login
1547: null, -- program_application_id,??
1548: null, -- program_id,??
1549: sysdate -- program_update_date
1550: from bom_parameters bp, bom_bill_of_materials bbom
1551: where bp.organization_id = pRcvOrgId
1552: and bp.organization_id = bbom.organization_id (+)
1553: and pModelItemId = bbom.assembly_item_id (+)
1554: and bbom.alternate_bom_designator is null

Line 1661: from bom_parameters bp, bom_bill_of_materials bbom

1657: gLoginId, -- last_update_login
1658: null, -- program_application_id,??
1659: null, -- program_id,??
1660: sysdate -- program_update_date
1661: from bom_parameters bp, bom_bill_of_materials bbom
1662: where bp.organization_id = pRcvOrgId
1663: and bp.organization_id = bbom.organization_id (+)
1664: and pModelItemId = bbom.assembly_item_id (+)
1665: and bbom.alternate_bom_designator is null

Line 1777: from bom_parameters bp, bom_bill_of_materials bbom

1773: gLoginId, -- last_update_login
1774: null, -- program_application_id,??
1775: null, -- program_id,??
1776: sysdate -- program_update_date
1777: from bom_parameters bp, bom_bill_of_materials bbom
1778: where bp.organization_id = pRcvOrgId
1779: and bp.organization_id = bbom.organization_id (+)
1780: and pModelItemId = bbom.assembly_item_id (+)
1781: and bbom.alternate_bom_designator is null

Line 2259: from bom_parameters bp

2255: gLoginId, -- last_update_login
2256: null, -- program_application_id,??
2257: null, -- program_id,??
2258: sysdate -- program_update_date
2259: from bom_parameters bp
2260: where bp.organization_id = l_curr_src_org
2261: and NOT EXISTS /* NOT EXISTS should be there to check whether same org is reached thru other paths */
2262: (select NULL
2263: from bom_cto_src_orgs_b

Line 2357: from bom_parameters bp

2353: gLoginId, -- last_update_login
2354: null, -- program_application_id,??
2355: null, -- program_id,??
2356: sysdate -- program_update_date
2357: from bom_parameters bp
2358: where bp.organization_id = l_curr_src_org
2359: and NOT EXISTS /* NOT EXISTS should be there to check whether same org is reached thru other paths */
2360: (select NULL
2361: from bom_cto_src_orgs_b

Line 2554: from bom_bill_of_materials bom, bom_parameters bp

2550: gLoginId, -- last_update_login
2551: null, -- program_application_id,??
2552: null, -- program_id,??
2553: sysdate -- program_update_date
2554: from bom_bill_of_materials bom, bom_parameters bp
2555: where p_organization_id = bp.organization_id
2556: and p_model_item_id = bom.assembly_item_id(+)
2557: and bp.organization_id = bom.organization_id(+)
2558: and bom.alternate_bom_designator is null

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

4772: gLoginId, -- last_update_login
4773: null, -- program_application_id,??
4774: null, -- program_id,??
4775: sysdate -- program_update_date
4776: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4777: where msi.inventory_item_id = p_model_item_id
4778: and msi.inventory_item_id = bom.assembly_item_id(+)
4779: and msi.organization_id = bom.organization_id(+)
4780: and bom.alternate_bom_designator is null

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

4852: gLoginId, -- last_update_login
4853: null, -- program_application_id,??
4854: null, -- program_id,??
4855: sysdate -- program_update_date
4856: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4857: where msi.inventory_item_id = p_model_item_id
4858: and msi.inventory_item_id = bom.assembly_item_id(+)
4859: and msi.organization_id = bom.organization_id(+)
4860: and bom.alternate_bom_designator is null

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

5009: gLoginId, -- last_update_login
5010: null, -- program_application_id,??
5011: null, -- program_id,??
5012: sysdate -- program_update_date
5013: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
5014: where msi.inventory_item_id = p_model_item_id
5015: and msi.inventory_item_id = bom.assembly_item_id(+)
5016: and msi.organization_id = bom.organization_id(+)
5017: and bom.alternate_bom_designator is null

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

5679: and model_item_id = p_model_item_id
5680: and organization_id = v_receiving_org
5681: and rcv_org_id = v_receiving_org
5682: and exists
5683: ( select * from bom_parameters bp, bom_bill_of_materials bbom
5684: where bp.organization_id = v_receiving_org
5685: and bbom.organization_id = bp.organization_id
5686: and bbom.assembly_item_id = p_model_item_id
5687: and bp.create_config_bom = 'Y' ) ;

Line 5715: from bom_parameters bp, bom_bill_of_materials bbom

5711: where line_id = p_line_id
5712: and model_item_id = p_model_item_id
5713: and rcv_org_id in (
5714: select bp.organization_id
5715: from bom_parameters bp, bom_bill_of_materials bbom
5716: where bbom.organization_id = bp.organization_id
5717: and bbom.assembly_item_id = p_model_item_id
5718: and bp.create_config_bom = 'Y' )
5719: and rownum = 1 ;