APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on GL_SUBR_LED

Line 1551: gl_subr_led led,

1547: s_request_id
1548: from
1549: OPI_DBI_OPM_SCALED_MTL scaled,
1550: gme_material_details coprod,
1551: gl_subr_led led,
1552: (
1553: SELECT
1554: jobs.Organization_id,
1555: jobs.Job_Id,

Line 1700: gl_subr_led sub

1696: sub.line_id,
1697: TRUNC(sub.gl_trans_date) gl_trans_date,
1698: SUM(sub.amount_base * sub.debit_credit_sign) amount_base
1699: FROM
1700: gl_subr_led sub
1701: WHERE
1702: sub.gl_trans_date >= s_global_start_date AND
1703: sub.acct_ttl_type = 1500 AND
1704: sub.doc_type = 'PROD'