APPS.CTO_UPDATE_BOM_RTG_PK dependencies on MTL_PARAMETERS

Line 615: FROM mtl_parameters mp, bom_cto_order_lines_upg bcol

611: exception
612: when no_data_found then
613: SELECT master_organization_id
614: INTO lOEValidationOrg
615: FROM mtl_parameters mp, bom_cto_order_lines_upg bcol
616: WHERE bcol.ship_from_org_id = mp.organization_id
617: and bcol.line_id = pLineid;
618: end; --Bugfix 6376208: The main query will run into no data found if SO having line_id has been purged.
619:

Line 1153: mtl_parameters mp

1149: into lEstRelDate
1150: from bom_calendar_dates cal,
1151: mtl_system_items msi,
1152: bom_cto_order_lines_upg bcolu,
1153: mtl_parameters mp
1154: where msi.organization_id = pOrgId
1155: and msi.inventory_item_id = pModelId
1156: and bcolu.line_id = pLineId
1157: and bcolu.inventory_item_id = msi.inventory_item_id

Line 1842: from mtl_parameters

1838: lStmtNum := 54;
1839: WriteToLog('Select Org.. ' ,5);
1840: select organization_code
1841: into lOrg_code
1842: from mtl_parameters
1843: where organization_id =pOrgId ;
1844:
1845: if ( lcreate_item = 1 ) then
1846: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++', 1);

Line 2394: mtl_parameters mp

2390: bor.project_id,
2391: bor.task_id
2392: from
2393: bom_operational_routings bor,
2394: mtl_parameters mp
2395: where bor.assembly_item_id = pModelId
2396: and bor.organization_id = pOrgId
2397: and bor.alternate_routing_designator is null
2398: and mp.organization_id = pOrgId;

Line 5199: mtl_parameters mp,

5195: NULL, /* ATTRIBUTE13 */
5196: NULL, /* ATTRIBUTE14 */
5197: NULL /* ATTRIBUTE15 */
5198: from bom_operational_routings bor,
5199: mtl_parameters mp,
5200: bom_cto_order_lines_upg bcolu
5201: where bcolu.sequence = p_seq
5202: and bcolu.status = 'BOM_LOOP'
5203: and bcolu.config_item_id = bor.assembly_item_id