DBA Data[Home] [Help]

APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on GME_BATCH_STEP_RESOURCES

Line 653: GME_BATCH_STEP_RESOURCES gbsr

649: 0,
650: gbsr.batchstep_resource_id line_id
651: from
652: OPI_DBI_JOBS_F jobs,
653: GME_BATCH_STEP_RESOURCES gbsr
654: where
655: jobs.job_id = gbsr.batch_id and
656: jobs.status = 'Closed' and
657: jobs.source = 3) jobs

Line 963: GME_BATCH_STEP_RESOURCES gbsr

959: jobs.conversion_rate,
960: jobs.sec_conversion_rate
961: from
962: OPI_DBI_JOBS_F jobs,
963: GME_BATCH_STEP_RESOURCES gbsr
964: where
965: jobs.job_id = gbsr.batch_id and
966: jobs.source = 2 and
967: jobs.status in ('Closed') and

Line 1368: GME_BATCH_STEP_RESOURCES gbsr

1364: -1 Line_type,
1365: jobs.Organization_id
1366: from
1367: OPI_DBI_JOBS_STG jobs,
1368: GME_BATCH_STEP_RESOURCES gbsr
1369: where
1370: jobs.job_id = gbsr.batch_id and
1371: jobs.source = 2 and
1372: jobs.status in ('Closed') and

Line 1826: GME_BATCH_STEP_RESOURCES gbsr

1822: -1 line_type,
1823: jobs.Organization_id
1824: from
1825: OPI_DBI_JOBS_F jobs,
1826: GME_BATCH_STEP_RESOURCES gbsr
1827: where
1828: jobs.source = 2 and
1829: jobs.line_type = 1 and
1830: jobs.job_id = gbsr.batch_id and