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