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_CONFIG_ITEM_PK dependencies on MTL_PARAMETERS

Line 2184: mtl_parameters mp,

2180: mtl_system_items msi2, /* CHILD */
2181: bom_inventory_components bic,
2182: eng_revised_items eri,
2183: bom_bill_of_materials bom,
2184: mtl_parameters mp,
2185: bom_explosion_temp be
2186: where be.sort_order <> 3 -- 1288823
2187: and be.group_id = xGrpId
2188: and nvl(be.plan_level,0) = level_number

Line 2591: mtl_parameters mp,

2587: mtl_system_items msi2,
2588: bom_inventory_components bic,
2589: eng_revised_items eri,
2590: bom_bill_of_materials bom,
2591: mtl_parameters mp,
2592: bom_explosion_temp be
2593: where be.sort_order <> 3
2594: and be.group_id = xGrpId
2595: and nvl(be.plan_level,0) = level_number

Line 3124: mtl_parameters mp,

3120: mtl_system_items msi2, /* CHILD [BUG#1518894] */
3121: bom_inventory_components bic,
3122: eng_revised_items eri,
3123: bom_bill_of_materials bom,
3124: mtl_parameters mp,
3125: bom_explosion_temp be
3126: where be.sort_order <> 3
3127: and be.group_id = xGrpId
3128: and nvl(be.plan_level,0) = level_number

Line 3538: mtl_parameters mp,

3534: mtl_system_items msi2,
3535: bom_inventory_components bic,
3536: eng_revised_items eri,
3537: bom_bill_of_materials bom,
3538: mtl_parameters mp,
3539: bom_explosion_temp be
3540: where be.sort_order <> 3
3541: and be.group_id = xGrpId
3542: and nvl(be.plan_level,0) = level_number

Line 6032: from mtl_parameters mp1,

6028: MP1.organization_id org_id,
6029: DECODE(MP1.ORGANIZATION_ID, lShipFromOrg ,l_cost_group_id,1) cost_group_id
6030: /*
6031: commented due to reintroduction of bcso
6032: from mtl_parameters mp1,
6033: cst_item_costs c,
6034: mtl_system_items msi
6035: where c.organization_id = mp1.organization_id
6036: and c.inventory_item_id = pModelId

Line 6046: from mtl_parameters mp1,

6042: from cst_quantity_layers
6043: where inventory_item_id = pConfigId
6044: and organization_id = mp1.organization_id);
6045: */
6046: from mtl_parameters mp1,
6047: mtl_parameters mp2,
6048: cst_item_costs c,
6049: bom_cto_src_orgs bcso
6050: where c.organization_id = mp1.organization_id

Line 6047: mtl_parameters mp2,

6043: where inventory_item_id = pConfigId
6044: and organization_id = mp1.organization_id);
6045: */
6046: from mtl_parameters mp1,
6047: mtl_parameters mp2,
6048: cst_item_costs c,
6049: bom_cto_src_orgs bcso
6050: where c.organization_id = mp1.organization_id
6051: and c.inventory_item_id = pModelId

Line 6287: mtl_parameters mp1

6283: sysdate
6284: from
6285: mtl_system_items m,
6286: bom_cto_src_orgs bcso,
6287: mtl_parameters mp1
6288: where m.inventory_item_id = pModelId
6289: and bcso.model_item_id = pModelId
6290: and bcso.line_id = pLineId
6291: and m.organization_id = bcso.organization_id

Line 6374: mtl_parameters MP1,

6370: l_rt_cicd_summary.resource_cost,
6371: l_rt_cicd_summary.outside_processing_cost,
6372: l_rt_cicd_summary.overhead_cost
6373: from
6374: mtl_parameters MP1,
6375: cst_item_costs C,
6376: cst_item_cost_details CICD,
6377: mtl_system_items S -- 4172300
6378: where S.organization_id = C.organization_id

Line 6390: from mtl_parameters mp2, mtl_parameters mp3, bom_cto_src_orgs bcso

6386: and C.cost_type_id = CICD.cost_type_id(+)
6387: and CICD.rollup_source_type(+) = 1 -- User Defined
6388: --4172300
6389: and MP1.organization_id in ( select distinct MP2.cost_organization_id
6390: from mtl_parameters mp2, mtl_parameters mp3, bom_cto_src_orgs bcso
6391: where bcso.model_item_id = pModelId
6392: and bcso.line_id = pLineId
6393: and MP3.organization_id = bcso.organization_id
6394: and ((mp2.organization_id = bcso.organization_id) OR

Line 6554: mtl_parameters MP1,

6550: C.attribute13,
6551: C.attribute14,
6552: C.attribute15
6553: from
6554: mtl_parameters MP1,
6555: cst_item_costs C,
6556: mtl_system_items S,
6557: bom_cto_src_orgs bcso
6558: where S.organization_id = C.organization_id

Line 6772: mtl_parameters MP1,

6768: C.attribute13,
6769: C.attribute14,
6770: C.attribute15
6771: from
6772: mtl_parameters MP1,
6773: cst_item_costs C,
6774: mtl_system_items S,
6775: bom_cto_src_orgs bcso
6776: where S.organization_id = C.organization_id

Line 6932: mtl_parameters MP1,

6928: C.attribute13,
6929: C.attribute14,
6930: C.attribute15
6931: from
6932: mtl_parameters MP1,
6933: cst_item_cost_details C,
6934: mtl_system_items S,
6935: bom_cto_src_orgs bcso
6936: where S.organization_id = C.organization_id

Line 7056: mtl_parameters MP1,

7052: C.attribute13,
7053: C.attribute14,
7054: C.attribute15
7055: from
7056: mtl_parameters MP1,
7057: cst_item_cost_details C,
7058: mtl_system_items S,
7059: bom_cto_src_orgs bcso
7060: where S.organization_id = C.organization_id

Line 9017: mtl_parameters mp1,

9013: 1, --would be 1 for initial creation of item
9014: MTL_ITEM_REVISIONS_B_S.nextval, -- 3338108 --:x_item_rev_seq --revision_id is generated from sequence
9015: mp1.starting_revision --3340844
9016: from
9017: mtl_parameters mp1,
9018: mtl_system_items m
9019: where m.inventory_item_id = pConfigId
9020: and m.organization_id = mp1.organization_id
9021: and NOT EXISTS

Line 9075: mtl_parameters mp1,

9071: sysdate,
9072: gUserId, --created_by
9073: gLoginId --last_update_login
9074: from
9075: mtl_parameters mp1,
9076: mtl_system_items_tl m,
9077: bom_cto_src_orgs bcso,
9078: fnd_languages l,
9079: mtl_item_revisions_b mr, --3338108

Line 9080: mtl_parameters mp2 --4109427

9076: mtl_system_items_tl m,
9077: bom_cto_src_orgs bcso,
9078: fnd_languages l,
9079: mtl_item_revisions_b mr, --3338108
9080: mtl_parameters mp2 --4109427
9081: where m.inventory_item_id = pModelId
9082: and bcso.model_item_id = m.inventory_item_id
9083: and bcso.line_id = pLineId
9084: and m.organization_id = mp1.organization_id