DBA Data[Home] [Help]

APPS.OPI_DBI_JOBS_PKG dependencies on GME_BATCH_HEADER

Line 968: gme_batch_header hdr

964: g_program_login_id,
965: g_program_application_id,
966: g_request_id
967: FROM gme_material_details dtl,
968: gme_batch_header hdr
969: WHERE
970: hdr.batch_id = dtl.batch_id
971: and dtl.line_type in (1,2) /* coproducts, by-products */
972: and batch_status in (2,3,4,-1) /* wip, completed, closed, cancelled */

Line 1376: gme_batch_header hdr

1372: g_program_login_id PROGRAM_LOGIN_ID,
1373: g_program_application_id PROGRAM_APPLICATION_ID,
1374: g_request_id REQUEST_ID
1375: from gme_material_details dtl,
1376: gme_batch_header hdr
1377: where hdr.batch_id = dtl.batch_id
1378: and dtl.line_type in (1,2) /* coproducts and by-products*/
1379: and nvl(ACTUAL_START_DATE, g_global_start_date) >= g_global_start_date
1380: and