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

Line 389: -- mtl_parameters table.

385: -- global start date for each org, item, cost group and pick the
386: -- prior cost of the transaction.
387: --
388: -- The cost method for all orgs is a non-null column of the
389: -- mtl_parameters table.
390: --
391: -- Since we want cost group information, use the non-null default
392: -- cost group id from mtl_parameters for standard costing orgs. For
393: -- layer costing orgs, get the cost group from MMT and if that is

Line 392: -- cost group id from mtl_parameters for standard costing orgs. For

388: -- The cost method for all orgs is a non-null column of the
389: -- mtl_parameters table.
390: --
391: -- Since we want cost group information, use the non-null default
392: -- cost group id from mtl_parameters for standard costing orgs. For
393: -- layer costing orgs, get the cost group from MMT and if that is
394: -- null, then replace it with default cost group.
395:
396: l_stmt_num :=10;

Line 414: parallel(mtl_parameters) */

410: max(csc.standard_cost) *onhand_qty onhand_value_b,
411: max(csc.standard_cost) *intransit_qty intransit_value_b
412: FROM (
413: SELECT /*+ use_hash(p csc) parallel(csc)
414: parallel(mtl_parameters) */
415: csc.organization_id,
416: csc.inventory_item_id,
417: -- this is a a timestamp hence max would
418: -- give unique record.

Line 422: FROM mtl_parameters p,

418: -- give unique record.
419: max(standard_cost_revision_date) standard_cost_revision_date,
420: p.primary_cost_method cost_method,
421: NULL cost_group_id -- RS: Bug fix 5219487 p.default_cost_group_id cost_group_id
422: FROM mtl_parameters p,
423: cst_standard_costs csc
424: -- not using <= below because txns are
425: -- collected from GSD onward. hence if there is
426: -- any cost update as of GSD additional 24 txns

Line 490: mtl_parameters p

486: NULL cost_group_id, --RS: Bug fix 5219487 nvl (mmt.cost_group_id, p.default_cost_group_id) cost_group_id,
487: min(mmt.transaction_id) trx_id
488: FROM mtl_material_transactions mmt,
489: OPI_DBI_INV_BEG_STG stg,
490: mtl_parameters p
491: WHERE primary_cost_method = 1
492: AND stg.organization_id = p.organization_id
493: AND stg.inventory_item_id = mmt.inventory_item_id
494: AND stg.organization_id = mmt.organization_id

Line 582: mtl_parameters p

578: p.primary_cost_method cost_method,
579: min(mmt.transaction_id) trx_id
580: FROM mtl_material_transactions mmt,
581: OPI_DBI_INV_BEG_STG stg,
582: mtl_parameters p
583: WHERE primary_cost_method <> 1
584: AND stg.organization_id = p.organization_id
585: AND stg.inventory_item_id = mmt.inventory_item_id
586: AND stg.organization_id = mmt.organization_id

Line 631: mtl_parameters mp

627: (SELECT
628: nvl(cst.item_cost,0) * onhand_qty onhand_value_b,
629: nvl(cst.item_cost,0) * intransit_qty intransit_value_b
630: FROM cst_quantity_layers cst,
631: mtl_parameters mp
632: WHERE mp.organization_id = fact.organization_id
633: AND primary_cost_method <> 1
634: AND cst.organization_id = fact.organization_id
635: AND cst.cost_group_id = fact.cost_group_id

Line 745: mtl_parameters p

741: fact.organization_id,
742: fact.inventory_item_id,
743: fact.transaction_date
744: FROM OPI_DBI_INV_BEG_STG fact,
745: mtl_parameters p
746: WHERE fact.organization_id = p.organization_id
747: AND p.process_enabled_flag ='Y'
748: ORDER BY fact.organization_id ,
749: fact.inventory_item_id,

Line 775: FROM dual, mtl_parameters mp

771: SET (onhand_value_b ,intransit_value_b, COST_FOUND_FLAG) =
772: (SELECT onhand_qty * GET_OPM_ITEM_COST(fact.organization_id, fact.inventory_item_id,fact.transaction_date) onhand_value_b,
773: intransit_qty * GET_OPM_ITEM_COST(fact.organization_id, fact.inventory_item_id,fact.transaction_date) intransit_value_b,
774: NULL
775: FROM dual, mtl_parameters mp
776: WHERE mp.organization_id =fact .organization_id
777: AND mp.process_enabled_flag ='Y'
778: );*/
779: FOR opm_org_cost_info IN opm_org_cost_csr

Line 918: --While collecting data we will map it with MTL_Parameters. To get cost

914: -- 21 - Intransit Shipment
915: -- 24 - Cost Update ODM
916: -- 15 - Logical Intransit Receipt
917: -- 22 - Logical Intransit Shipment
918: --While collecting data we will map it with MTL_Parameters. To get cost
919: --group Id for discrete Organization and Process Enabled flag for
920:
921: PROCEDURE INTRANSIT_SETUP(p_mode varchar2)
922: IS

Line 966: from MTL_PARAMETERS mp,

962: -- Customers might have this too
963: DECODE(mp.process_enabled_flag,'1','N',mp.process_enabled_flag),
964: transaction_action_id, -- intransit shipment
965: fob_point
966: from MTL_PARAMETERS mp,
967: (SELECT /*+ parallel(mip) */
968: from_organization_id,
969: to_organization_id,
970: DECODE(fob_point,1,to_organization_id,

Line 1006: -- cost group associated with the organization in MTL_PARAMETERS.

1002: --
1003: --
1004: -- Additionally, pick up a cost group associated with each
1005: -- transaction. For standard costing orgs, use the default
1006: -- cost group associated with the organization in MTL_PARAMETERS.
1007: -- As of 11i, the default_cost_group_id is guaranteed to be
1008: -- non-null, so no nvl is needed on the selection of that column.
1009:
1010: INSERT /*append parallel(opi_dbi_intr_mmt_tmp) */

Line 1045: MTL_PARAMETERS p,

1041: 24, 0,
1042: mmt.primary_quantity),
1043: transaction_date
1044: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1045: MTL_PARAMETERS p,
1046: MTL_PARAMETERS p1
1047: WHERE mmt.transaction_action_id in (12,21,24,15,22)
1048: AND mmt.transaction_date >= g_global_start_date
1049: AND p.organization_id = mmt.organization_id

Line 1046: MTL_PARAMETERS p1

1042: mmt.primary_quantity),
1043: transaction_date
1044: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1045: MTL_PARAMETERS p,
1046: MTL_PARAMETERS p1
1047: WHERE mmt.transaction_action_id in (12,21,24,15,22)
1048: AND mmt.transaction_date >= g_global_start_date
1049: AND p.organization_id = mmt.organization_id
1050: AND p1.organization_id = mmt.transfer_organization_id

Line 1240: MTL_PARAMETERS mp,

1236: mmt1.cost_group_id)
1237: ),-1) cost_group_id
1238: FROM OPI_DBI_INTR_MMT_TMP mmt1,
1239: OPI_DBI_INTR_MIP_TMP mip,
1240: MTL_PARAMETERS mp,
1241: MTL_SYSTEM_ITEMS msi_fm,
1242: MTL_SYSTEM_ITEMS msi_to
1243: WHERE mmt1.organization_id = mip.from_organization_id
1244: AND mmt1.transfer_organization_id = mip.to_organization_id

Line 1286: MTL_PARAMETERS p

1282: nvl (sup.cost_group_id, p.default_cost_group_id)
1283: cost_group_id
1284: FROM OPI_DBI_INTR_SUP_TMP sup,
1285: MTL_SYSTEM_ITEMS msi,
1286: MTL_PARAMETERS p
1287: WHERE sup.intransit_owning_org_id = msi.organization_id
1288: AND p.organization_id = msi.organization_id
1289: AND sup.item_id = msi.inventory_item_id
1290: GROUP BY sup.intransit_owning_org_id,

Line 1992: ,MTL_PARAMETERS MP

1988: 'MMT' transaction_source
1989: FROM MTL_MATERIAL_TRANSACTIONS MMT
1990: -- ,MTL_SYSTEM_ITEMS MSI
1991: ,OPI_DBI_CONC_PROG_RUN_LOG PRL
1992: ,MTL_PARAMETERS MP
1993: WHERE prl.driving_table_code (+)= 'MMT' --bug 4704813
1994: AND prl.etl_type (+)= 'INVENTORY'
1995: AND prl.load_type (+)= 'INIT'
1996: AND mmt.transaction_id >= nvl(prl.from_bound_id,0) --bug 4704813

Line 2035: ,MTL_PARAMETERS MP

2031: 'N' push_to_fact_flag,
2032: NULL source,
2033: 'MOQ' transaction_source
2034: FROM MTL_ONHAND_QUANTITIES MOQ
2035: ,MTL_PARAMETERS MP
2036: ,MTL_SYSTEM_ITEMS MSI
2037: WHERE moq.organization_id = mp.organization_id
2038: AND moq.organization_id = msi.organization_id
2039: AND moq.inventory_item_id = msi.inventory_item_id

Line 2607: mtl_parameters mp

2603: 0 intransit_value_b_draft,
2604: 0 wip_value_b_draft,
2605: decode(mp.process_enabled_flag,'Y',2,1) source
2606: FROM OPI_DBI_INV_BEG_STG fact,
2607: mtl_parameters mp
2608: WHERE fact.organization_id =mp.organization_id
2609: union all
2610: select /*+ parallel(OPI_DBI_OPM_INV_STG) */
2611: organization_id,