APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_PARAMETERS

Line 924: mtl_parameters mp1

920: from
921: cst_item_costs c,
922: bom_cto_src_orgs bcso,
923: bom_cto_order_lines_upg bcolu,
924: mtl_parameters mp1
925: where bcolu.config_item_id is not null
926: and bcolu.status = 'BCSO'
927: and c.organization_id = bcso.organization_id
928: and c.inventory_item_id = bcolu.inventory_item_id

Line 1156: mtl_parameters mp1,

1152: 1, --would be 1 for initial creation of item
1153: MTL_ITEM_REVISIONS_B_S.nextval, -- 3338108 --l_rev_id, --revision_id is generated from sequence
1154: mp1.starting_revision --3340844
1155: from
1156: mtl_parameters mp1,
1157: mtl_system_items m
1158: where m.inventory_item_id = v_bcolu_cfg.config_item_id
1159: and m.organization_id = mp1.organization_id
1160: and NOT EXISTS

Line 1257: mtl_parameters MP1,

1253: l_rt_cicd_summary.resource_cost,
1254: l_rt_cicd_summary.outside_processing_cost,
1255: l_rt_cicd_summary.overhead_cost
1256: from
1257: mtl_parameters MP1,
1258: cst_item_costs C,
1259: cst_item_cost_details CICD,
1260: bom_cto_order_lines_upg bcolu
1261: where

Line 1275: from mtl_parameters mp2,

1271: ( select
1272: bcolu.line_id,
1273: bcolu.inventory_item_id,
1274: MP2.cost_organization_id
1275: from mtl_parameters mp2,
1276: mtl_parameters mp3,
1277: bom_cto_src_orgs bcso,
1278: bom_cto_order_lines_upg bcolu
1279: where bcolu.config_item_id is not null

Line 1276: mtl_parameters mp3,

1272: bcolu.line_id,
1273: bcolu.inventory_item_id,
1274: MP2.cost_organization_id
1275: from mtl_parameters mp2,
1276: mtl_parameters mp3,
1277: bom_cto_src_orgs bcso,
1278: bom_cto_order_lines_upg bcolu
1279: where bcolu.config_item_id is not null
1280: and bcolu.status = 'BCSO'

Line 1447: mtl_parameters MP1,

1443: C.attribute13,
1444: C.attribute14,
1445: C.attribute15
1446: from
1447: mtl_parameters MP1,
1448: cst_item_costs C,
1449: mtl_system_items S,
1450: bom_cto_src_orgs bcso,
1451: bom_cto_order_lines_upg bcolu

Line 1670: mtl_parameters MP1,

1666: C.attribute13,
1667: C.attribute14,
1668: C.attribute15
1669: from
1670: mtl_parameters MP1,
1671: cst_item_costs C,
1672: mtl_system_items S,
1673: bom_cto_src_orgs bcso,
1674: bom_cto_order_lines_upg bcolu

Line 1833: mtl_parameters MP1,

1829: C.attribute13,
1830: C.attribute14,
1831: C.attribute15
1832: from
1833: mtl_parameters MP1,
1834: cst_item_cost_details C,
1835: mtl_system_items S,
1836: bom_cto_src_orgs bcso,
1837: bom_cto_order_lines_upg bcolu

Line 1955: mtl_parameters MP1,

1951: C.attribute13,
1952: C.attribute14,
1953: C.attribute15
1954: from
1955: mtl_parameters MP1,
1956: cst_item_cost_details C,
1957: mtl_system_items S,
1958: bom_cto_src_orgs bcso,
1959: bom_cto_order_lines_upg bcolu

Line 3594: mtl_parameters mp1,

3590: 3,
3591: 2
3592:
3593: from
3594: mtl_parameters mp1,
3595: mtl_system_items_b m, -- model
3596: mtl_system_items_b c, -- config
3597: bom_cto_src_orgs bcso,
3598: bom_cto_order_lines_upg bcolu