DBA Data[Home] [Help]

APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on IC_TRAN_PND

Line 1566: IC_TRAN_PND itp

1562: itp.trans_date,
1563: itp.line_type
1564: FROM
1565: OPI_DBI_JOBS_F jobs,
1566: IC_TRAN_PND itp
1567: WHERE
1568: jobs.source = 3 AND
1569: itp.completed_ind = 1 AND
1570: itp.doc_type = 'PROD' AND

Line 1678: ic_tran_pnd

1674: orgn_code,
1675: item_id,
1676: SUM(trans_qty) trans_qty
1677: FROM
1678: ic_tran_pnd
1679: WHERE
1680: doc_type = 'PROD' AND
1681: line_type IN (1,2) AND
1682: completed_ind = 1 AND