APPS.OPI_DBI_COMMON_MOD_INIT_PKG dependencies on MTL_PARAMETERS

Line 546: (SELECT /*+ parallel (mtl_parameters) */

542: FROM mtl_material_transactions
543: WHERE costed_flag IN ('N', 'E')
544: AND transaction_id > l_mmt_start_txn_id
545: GROUP BY organization_id) uncosted,
546: (SELECT /*+ parallel (mtl_parameters) */
547: organization_id
548: FROM mtl_parameters
549: WHERE process_enabled_flag <> 'Y') orgs
550: WHERE orgs.organization_id = uncosted.organization_id (+))

Line 548: FROM mtl_parameters

544: AND transaction_id > l_mmt_start_txn_id
545: GROUP BY organization_id) uncosted,
546: (SELECT /*+ parallel (mtl_parameters) */
547: organization_id
548: FROM mtl_parameters
549: WHERE process_enabled_flag <> 'Y') orgs
550: WHERE orgs.organization_id = uncosted.organization_id (+))
551: mmt_bounds,
552: mtl_material_transactions mmt

Line 1263: mtl_parameters mp,

1259: STOP_UNCOSTED, 'Uncosted',
1260: 'Data Issue?') stop_reason,
1261: nvl (mmt.transaction_date, sysdate) data_until
1262: FROM opi_dbi_run_log_curr log,
1263: mtl_parameters mp,
1264: mtl_material_transactions mmt
1265: WHERE source = OPI_SOURCE
1266: AND etl_id = JOB_TXN_ETL -- any ETL is good enough
1267: AND log.next_start_txn_id = mmt.transaction_id (+)