APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MTL_PARAMETERS

Line 672: FROM mtl_parameters mp, bom_cto_order_lines_upg bcol

668: exception
669: when no_data_found then
670: SELECT master_organization_id
671: INTO lOEValidationOrg
672: FROM mtl_parameters mp, bom_cto_order_lines_upg bcol
673: WHERE bcol.ship_from_org_id = mp.organization_id
674: and bcol.line_id = pLineid;
675: end; --Bugfix 6376208: The main query will run into no data found if SO having line_id has been purged.
676:

Line 1212: mtl_parameters mp

1208: into lEstRelDate
1209: from bom_calendar_dates cal,
1210: mtl_system_items msi,
1211: bom_cto_order_lines_upg bcolu,
1212: mtl_parameters mp
1213: where msi.organization_id = pOrgId
1214: and msi.inventory_item_id = pModelId
1215: and bcolu.line_id = pLineId
1216: and bcolu.inventory_item_id = msi.inventory_item_id

Line 1931: from mtl_parameters

1927: lStmtNum := 54;
1928: WriteToLog('Select Org.. ' ,5);
1929: select organization_code
1930: into lOrg_code
1931: from mtl_parameters
1932: where organization_id =pOrgId ;
1933:
1934: if ( lcreate_item = 1 ) then
1935: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++', 1);

Line 2483: mtl_parameters mp

2479: bor.project_id,
2480: bor.task_id
2481: from
2482: bom_operational_routings bor,
2483: mtl_parameters mp
2484: where bor.assembly_item_id = pModelId
2485: and bor.organization_id = pOrgId
2486: and bor.alternate_routing_designator is null
2487: and mp.organization_id = pOrgId;

Line 5408: mtl_parameters mp,

5404: NULL, /* ATTRIBUTE13 */
5405: NULL, /* ATTRIBUTE14 */
5406: NULL /* ATTRIBUTE15 */
5407: from bom_operational_routings bor,
5408: mtl_parameters mp,
5409: bom_cto_order_lines_upg bcolu
5410: where bcolu.sequence = p_seq
5411: and bcolu.status = 'BOM_LOOP'
5412: and bcolu.config_item_id = bor.assembly_item_id