APPS.OPI_DBI_BOUNDS_PKG dependencies on MTL_PARAMETERS

Line 816: FROM mtl_parameters mp ,

812: l_program_id ,
813: l_program_login_id ,
814: l_program_application_id,
815: l_request_id
816: FROM mtl_parameters mp ,
817: (
818: SELECT /*+ no_merge parallel(mmt) */ organization_id,min(transaction_id) transaction_id
819: FROM mtl_material_transactions mmt
820: WHERE transaction_date >= l_global_start_date

Line 882: /* open a cursor for holding all new organizations in mtl_parameters after previous INIT-INCR load */

878: l_program_application_id NUMBER ;
879: l_request_id NUMBER ;
880:
881:
882: /* open a cursor for holding all new organizations in mtl_parameters after previous INIT-INCR load */
883: CURSOR csr_get_new_org IS
884: SELECT DISTINCT organization_id
885: FROM mtl_parameters
886: WHERE process_enabled_flag <> 'Y'

Line 885: FROM mtl_parameters

881:
882: /* open a cursor for holding all new organizations in mtl_parameters after previous INIT-INCR load */
883: CURSOR csr_get_new_org IS
884: SELECT DISTINCT organization_id
885: FROM mtl_parameters
886: WHERE process_enabled_flag <> 'Y'
887: MINUS
888: SELECT DISTINCT bound_level_entity_id
889: FROM OPI_DBI_CONC_PROG_RUN_LOG

Line 1022: , mtl_parameters mp

1018: AND plog.bound_level_entity_code = 'ORGANIZATION'
1019: AND mmt.organization_id = plog.bound_level_entity_id) --Bug 5096963
1020: GROUP BY organization_id
1021: ) uncosted_trx
1022: , mtl_parameters mp
1023: where prlout.bound_level_entity_id = mp.organization_id
1024: and mp.organization_id = uncosted_trx.organization_id(+))
1025: WHERE prlout.driving_table_code = 'MMT'
1026: AND prlout.etl_type = p_etl_type

Line 1406: mtl_parameters mp,

1402: STOP_UNCOSTED, 'Uncosted',
1403: 'Data Issue?') stop_reason,
1404: nvl (mmt.transaction_date, sysdate) data_until
1405: FROM opi_dbi_conc_prog_run_log log,
1406: mtl_parameters mp,
1407: mtl_material_transactions mmt
1408: WHERE log.driving_table_code = 'MMT'
1409: AND log.to_bound_id = mmt.transaction_id (+)
1410: AND log.bound_level_entity_id = mp.organization_id

Line 1589: MTL_PARAMETERS mp

1585: gfp.legal_entity_id ,
1586: gfp.cost_type_id
1587: FROM ORG_ORGANIZATION_DEFINITIONS ood,
1588: GMF_FISCAL_POLICIES gfp,
1589: MTL_PARAMETERS mp
1590: WHERE mp.process_enabled_flag = 'Y' --for OPM orgs only
1591: AND mp.organization_id = ood.organization_id
1592: AND ood.legal_entity = gfp.legal_entity_id ;
1593: