eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PMI_LOT_GENEALOGY_PKG dependencies on IC_TRAN_PND

Line 38: ic_tran_pnd product, ic_tran_pnd ingred

34: SELECT
35: product.item_id product_item_id, product.lot_id product_lot_id,
36: ingred.item_id ingred_item_id, ingred.lot_id ingred_lot_id
37: FROM
38: ic_tran_pnd product, ic_tran_pnd ingred
39: WHERE
40: product.doc_type = 'PROD'
41: AND product.doc_id = cp_doc_id
42: AND product.line_type in (1,2)

Line 235: FROM ic_tran_pnd t

231: */
232: CURSOR updated_docs(cp_last_refresh_date DATE, cp_current_refresh_date DATE)
233: IS
234: SELECT DISTINCT doc_id
235: FROM ic_tran_pnd t
236: WHERE t.last_update_date BETWEEN NVL(cp_last_refresh_date, t.last_update_date)
237: AND cp_current_refresh_date
238: AND t.doc_type = 'PROD'
239: AND t.completed_ind = 1