APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_PARAMETERS

Line 1067: mtl_parameters mp1

1063: from
1064: cst_item_costs c,
1065: bom_cto_src_orgs bcso,
1066: bom_cto_order_lines_upg bcolu,
1067: mtl_parameters mp1
1068: where bcolu.config_item_id is not null
1069: and bcolu.status = 'BCSO'
1070: and c.organization_id = bcso.organization_id
1071: and c.inventory_item_id = bcolu.inventory_item_id

Line 1299: mtl_parameters mp1,

1295: 1, --would be 1 for initial creation of item
1296: MTL_ITEM_REVISIONS_B_S.nextval, -- 3338108 --l_rev_id, --revision_id is generated from sequence
1297: mp1.starting_revision --3340844
1298: from
1299: mtl_parameters mp1,
1300: mtl_system_items m
1301: where m.inventory_item_id = v_bcolu_cfg.config_item_id
1302: and m.organization_id = mp1.organization_id
1303: and NOT EXISTS

Line 1400: mtl_parameters MP1,

1396: l_rt_cicd_summary.resource_cost,
1397: l_rt_cicd_summary.outside_processing_cost,
1398: l_rt_cicd_summary.overhead_cost
1399: from
1400: mtl_parameters MP1,
1401: cst_item_costs C,
1402: cst_item_cost_details CICD,
1403: bom_cto_order_lines_upg bcolu
1404: where

Line 1418: from mtl_parameters mp2,

1414: ( select
1415: bcolu.line_id,
1416: bcolu.inventory_item_id,
1417: MP2.cost_organization_id
1418: from mtl_parameters mp2,
1419: mtl_parameters mp3,
1420: bom_cto_src_orgs bcso,
1421: bom_cto_order_lines_upg bcolu
1422: where bcolu.config_item_id is not null

Line 1419: mtl_parameters mp3,

1415: bcolu.line_id,
1416: bcolu.inventory_item_id,
1417: MP2.cost_organization_id
1418: from mtl_parameters mp2,
1419: mtl_parameters mp3,
1420: bom_cto_src_orgs bcso,
1421: bom_cto_order_lines_upg bcolu
1422: where bcolu.config_item_id is not null
1423: and bcolu.status = 'BCSO'

Line 1590: mtl_parameters MP1,

1586: C.attribute13,
1587: C.attribute14,
1588: C.attribute15
1589: from
1590: mtl_parameters MP1,
1591: cst_item_costs C,
1592: mtl_system_items S,
1593: bom_cto_src_orgs bcso,
1594: bom_cto_order_lines_upg bcolu

Line 1813: mtl_parameters MP1,

1809: C.attribute13,
1810: C.attribute14,
1811: C.attribute15
1812: from
1813: mtl_parameters MP1,
1814: cst_item_costs C,
1815: mtl_system_items S,
1816: bom_cto_src_orgs bcso,
1817: bom_cto_order_lines_upg bcolu

Line 1976: mtl_parameters MP1,

1972: C.attribute13,
1973: C.attribute14,
1974: C.attribute15
1975: from
1976: mtl_parameters MP1,
1977: cst_item_cost_details C,
1978: mtl_system_items S,
1979: bom_cto_src_orgs bcso,
1980: bom_cto_order_lines_upg bcolu

Line 2098: mtl_parameters MP1,

2094: C.attribute13,
2095: C.attribute14,
2096: C.attribute15
2097: from
2098: mtl_parameters MP1,
2099: cst_item_cost_details C,
2100: mtl_system_items S,
2101: bom_cto_src_orgs bcso,
2102: bom_cto_order_lines_upg bcolu

Line 3806: mtl_parameters mp1,

3802: 3,
3803: 2
3804:
3805: from
3806: mtl_parameters mp1,
3807: mtl_system_items_b m, -- model
3808: mtl_system_items_b c, -- config
3809: bom_cto_src_orgs bcso,
3810: bom_cto_order_lines_upg bcolu