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.CSTPMECS dependencies on MTL_PARAMETERS

Line 134: , mtl_parameters MP

130: WHERE L.list_id = I_LIST_ID
131: AND NOT EXISTS (
132: SELECT 'X'
133: FROM mtl_material_transactions M
134: , mtl_parameters MP
135: WHERE MP.cost_organization_id = I_ORG_ID
136: AND M.organization_id = MP.organization_id
137: AND M.inventory_item_id = L.ENTITY_ID
138: AND M.transaction_source_type_id = 1

Line 195: , mtl_parameters MP

191: , I_PROGRAM_APPL_ID
192: , I_PROGRAM_ID
193: , SYSDATE
194: FROM mtl_material_transactions MMT
195: , mtl_parameters MP
196: WHERE MP.cost_organization_id = I_ORG_ID
197: AND MMT.organization_id = MP.organization_id
198: AND MMT.transaction_type_id = 18
199: AND MMT.inventory_item_id = CICD.inventory_item_id

Line 279: , mtl_parameters MP

275: WHERE L.list_id = I_LIST_ID
276: AND NOT EXISTS (
277: SELECT 'X'
278: FROM mtl_material_transactions M
279: , mtl_parameters MP
280: WHERE MP.cost_organization_id = I_ORG_ID
281: AND M.organization_id = MP.organization_id
282: AND M.inventory_item_id = L.ENTITY_ID
283: AND M.transaction_source_type_id = 1

Line 394: mtl_parameters MP

390: , I_PROGRAM_ID
391: , SYSDATE
392:
393: FROM /* Select and Round FROM clause */
394: mtl_parameters MP
395: , mtl_secondary_inventories MSI
396: , mtl_onhand_quantities MOH
397: , mtl_material_transactions MMT
398:

Line 517: FROM mtl_parameters MP

513: UOM.conversion_rate), 0, 1,
514: SUM((POD.quantity_ordered - NVL(POD.quantity_delivered,0)) *
515: UOM.conversion_rate))) *
516: (1 + I_PER_INC/100) + I_AMT_INC
517: FROM mtl_parameters MP
518: , po_headers_all POH
519: , po_lines_all POL
520: , po_line_locations_all PLL
521: , po_distributions_all POD

Line 1023: , mtl_parameters MP

1019: (SELECT NVL(sum(quantity_invoiced * UCR.conversion_rate),0)
1020: FROM mtl_uom_conversions_view UCR
1021: , po_lines_all PL
1022: , po_distributions_all PD
1023: , mtl_parameters MP
1024: , ap_invoice_distributions_all AIP
1025: WHERE AIP.posted_flag = 'Y'
1026: AND (I_FROM_DATE IS NULL OR (I_FROM_DATE IS NOT NULL and AIP.accounting_date >= I_FROM_DATE))
1027: AND (I_TO_DATE IS NULL OR (I_TO_DATE IS NOT NULL and AIP.accounting_date <= I_TO_DATE))

Line 1055: , mtl_parameters MP

1051: (SELECT 1
1052: FROM mtl_uom_conversions_view UCR
1053: , po_lines_all PL
1054: , po_distributions_all PD
1055: , mtl_parameters MP
1056: , ap_invoice_distributions_all AIP
1057: WHERE NVL(AIP.posted_flag,'N') = 'Y'
1058: AND AIP.accounting_date
1059: BETWEEN NVL(I_FROM_DATE, AIP.accounting_date)

Line 1127: , mtl_parameters MP

1123: , SYSDATE
1124: FROM mtl_uom_conversions_view UCR
1125: , po_lines_all PL
1126: , po_distributions_all PD
1127: , mtl_parameters MP
1128: , ap_invoice_distributions_all AIP
1129: WHERE AIP.posted_flag = 'Y'
1130: AND (I_FROM_DATE IS NULL OR (I_FROM_DATE IS NOT NULL and AIP.accounting_date >= I_FROM_DATE))
1131: AND (I_TO_DATE IS NULL OR (I_TO_DATE IS NOT NULL and AIP.accounting_date <= I_TO_DATE))