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 2277: mtl_parameters mp,

2273: mtl_system_items msi2, /* CHILD */
2274: bom_inventory_components bic,
2275: eng_revised_items eri,
2276: bom_bill_of_materials bom,
2277: mtl_parameters mp,
2278: bom_explosion_temp be
2279: where be.sort_order <> 3 -- 1288823
2280: and be.group_id = xGrpId
2281: and nvl(be.plan_level,0) = level_number

Line 2684: mtl_parameters mp,

2680: mtl_system_items msi2,
2681: bom_inventory_components bic,
2682: eng_revised_items eri,
2683: bom_bill_of_materials bom,
2684: mtl_parameters mp,
2685: bom_explosion_temp be
2686: where be.sort_order <> 3
2687: and be.group_id = xGrpId
2688: and nvl(be.plan_level,0) = level_number

Line 3217: mtl_parameters mp,

3213: mtl_system_items msi2, /* CHILD [BUG#1518894] */
3214: bom_inventory_components bic,
3215: eng_revised_items eri,
3216: bom_bill_of_materials bom,
3217: mtl_parameters mp,
3218: bom_explosion_temp be
3219: where be.sort_order <> 3
3220: and be.group_id = xGrpId
3221: and nvl(be.plan_level,0) = level_number

Line 3631: mtl_parameters mp,

3627: mtl_system_items msi2,
3628: bom_inventory_components bic,
3629: eng_revised_items eri,
3630: bom_bill_of_materials bom,
3631: mtl_parameters mp,
3632: bom_explosion_temp be
3633: where be.sort_order <> 3
3634: and be.group_id = xGrpId
3635: and nvl(be.plan_level,0) = level_number

Line 6217: from mtl_parameters mp1,

6213: MP1.organization_id org_id,
6214: DECODE(MP1.ORGANIZATION_ID, lShipFromOrg ,l_cost_group_id,1) cost_group_id
6215: /*
6216: commented due to reintroduction of bcso
6217: from mtl_parameters mp1,
6218: cst_item_costs c,
6219: mtl_system_items msi
6220: where c.organization_id = mp1.organization_id
6221: and c.inventory_item_id = pModelId

Line 6231: from mtl_parameters mp1,

6227: from cst_quantity_layers
6228: where inventory_item_id = pConfigId
6229: and organization_id = mp1.organization_id);
6230: */
6231: from mtl_parameters mp1,
6232: mtl_parameters mp2,
6233: cst_item_costs c,
6234: bom_cto_src_orgs bcso
6235: where c.organization_id = mp1.organization_id

Line 6232: mtl_parameters mp2,

6228: where inventory_item_id = pConfigId
6229: and organization_id = mp1.organization_id);
6230: */
6231: from mtl_parameters mp1,
6232: mtl_parameters mp2,
6233: cst_item_costs c,
6234: bom_cto_src_orgs bcso
6235: where c.organization_id = mp1.organization_id
6236: and c.inventory_item_id = pModelId

Line 6472: mtl_parameters mp1

6468: sysdate
6469: from
6470: mtl_system_items m,
6471: bom_cto_src_orgs bcso,
6472: mtl_parameters mp1
6473: where m.inventory_item_id = pModelId
6474: and bcso.model_item_id = pModelId
6475: and bcso.line_id = pLineId
6476: and m.organization_id = bcso.organization_id

Line 6559: mtl_parameters MP1,

6555: l_rt_cicd_summary.resource_cost,
6556: l_rt_cicd_summary.outside_processing_cost,
6557: l_rt_cicd_summary.overhead_cost
6558: from
6559: mtl_parameters MP1,
6560: cst_item_costs C,
6561: cst_item_cost_details CICD,
6562: mtl_system_items S -- 4172300
6563: where S.organization_id = C.organization_id

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

6571: and C.cost_type_id = CICD.cost_type_id(+)
6572: and CICD.rollup_source_type(+) = 1 -- User Defined
6573: --4172300
6574: and MP1.organization_id in ( select distinct MP2.cost_organization_id
6575: from mtl_parameters mp2, mtl_parameters mp3, bom_cto_src_orgs bcso
6576: where bcso.model_item_id = pModelId
6577: and bcso.line_id = pLineId
6578: and MP3.organization_id = bcso.organization_id
6579: and ((mp2.organization_id = bcso.organization_id) OR

Line 6739: mtl_parameters MP1,

6735: C.attribute13,
6736: C.attribute14,
6737: C.attribute15
6738: from
6739: mtl_parameters MP1,
6740: cst_item_costs C,
6741: mtl_system_items S,
6742: bom_cto_src_orgs bcso
6743: where S.organization_id = C.organization_id

Line 6957: mtl_parameters MP1,

6953: C.attribute13,
6954: C.attribute14,
6955: C.attribute15
6956: from
6957: mtl_parameters MP1,
6958: cst_item_costs C,
6959: mtl_system_items S,
6960: bom_cto_src_orgs bcso
6961: where S.organization_id = C.organization_id

Line 7117: mtl_parameters MP1,

7113: C.attribute13,
7114: C.attribute14,
7115: C.attribute15
7116: from
7117: mtl_parameters MP1,
7118: cst_item_cost_details C,
7119: mtl_system_items S,
7120: bom_cto_src_orgs bcso
7121: where S.organization_id = C.organization_id

Line 7241: mtl_parameters MP1,

7237: C.attribute13,
7238: C.attribute14,
7239: C.attribute15
7240: from
7241: mtl_parameters MP1,
7242: cst_item_cost_details C,
7243: mtl_system_items S,
7244: bom_cto_src_orgs bcso
7245: where S.organization_id = C.organization_id

Line 9318: mtl_parameters mp1,

9314: 1, --would be 1 for initial creation of item
9315: MTL_ITEM_REVISIONS_B_S.nextval, -- 3338108 --:x_item_rev_seq --revision_id is generated from sequence
9316: mp1.starting_revision --3340844
9317: from
9318: mtl_parameters mp1,
9319: mtl_system_items m
9320: where m.inventory_item_id = pConfigId
9321: and m.organization_id = mp1.organization_id
9322: and NOT EXISTS

Line 9376: mtl_parameters mp1,

9372: sysdate,
9373: gUserId, --created_by
9374: gLoginId --last_update_login
9375: from
9376: mtl_parameters mp1,
9377: mtl_system_items_tl m,
9378: bom_cto_src_orgs bcso,
9379: fnd_languages l,
9380: mtl_item_revisions_b mr, --3338108

Line 9381: mtl_parameters mp2 --4109427

9377: mtl_system_items_tl m,
9378: bom_cto_src_orgs bcso,
9379: fnd_languages l,
9380: mtl_item_revisions_b mr, --3338108
9381: mtl_parameters mp2 --4109427
9382: where m.inventory_item_id = pModelId
9383: and bcso.model_item_id = m.inventory_item_id
9384: and bcso.line_id = pLineId
9385: and m.organization_id = mp1.organization_id