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.OPI_EDW_OPM_PRD_PKG dependencies on IC_TRAN_CMP

Line 7: TRANS_ID_V ic_TRAN_CMP.TRANS_id%TYPE := NULL;

3:
4: FUNCTION FIND_PROD_GRADE(TRANS_ID_VI IN INTEGER,ITEM_ID_VI IN INTEGER,LOT_ID_VI IN INTEGER)
5: RETURN VARCHAR2
6: IS
7: TRANS_ID_V ic_TRAN_CMP.TRANS_id%TYPE := NULL;
8: QC_GRADE_V ic_TRAN_CMP.QC_GRADE%TYPE := NULL;
9:
10: CURSOR GRADE_CHANGE_TRAN_CUR(
11: ITEM_ID_V ic_item_mst.item_id%TYPE,

Line 8: QC_GRADE_V ic_TRAN_CMP.QC_GRADE%TYPE := NULL;

4: FUNCTION FIND_PROD_GRADE(TRANS_ID_VI IN INTEGER,ITEM_ID_VI IN INTEGER,LOT_ID_VI IN INTEGER)
5: RETURN VARCHAR2
6: IS
7: TRANS_ID_V ic_TRAN_CMP.TRANS_id%TYPE := NULL;
8: QC_GRADE_V ic_TRAN_CMP.QC_GRADE%TYPE := NULL;
9:
10: CURSOR GRADE_CHANGE_TRAN_CUR(
11: ITEM_ID_V ic_item_mst.item_id%TYPE,
12: LOT_ID_V ic_lots_mst.lot_id%TYPE )

Line 14: SELECT nvl(max(trans_id),0) from ic_tran_cmp_vw1

10: CURSOR GRADE_CHANGE_TRAN_CUR(
11: ITEM_ID_V ic_item_mst.item_id%TYPE,
12: LOT_ID_V ic_lots_mst.lot_id%TYPE )
13: IS
14: SELECT nvl(max(trans_id),0) from ic_tran_cmp_vw1
15: where item_id = item_id_v
16: and lot_id = lot_id_v
17: and doc_type = 'GRDI'
18: and reason_code = fnd_profile.value('PMI$REASON_CODE');

Line 32: from ic_tran_cmp_vw1 where trans_id = trans_id_vi;

28:
29: FETCH GRADE_CHANGE_TRAN_CUR INTO trans_id_v;
30: IF trans_id_v = 0 THEN
31: SELECT QC_GRADE into qc_grade_v
32: from ic_tran_cmp_vw1 where trans_id = trans_id_vi;
33: else
34: SELECT QC_GRADE into qc_grade_v
35: from ic_tran_cmp_vw1 where trans_id = trans_id_v;
36: end if;

Line 35: from ic_tran_cmp_vw1 where trans_id = trans_id_v;

31: SELECT QC_GRADE into qc_grade_v
32: from ic_tran_cmp_vw1 where trans_id = trans_id_vi;
33: else
34: SELECT QC_GRADE into qc_grade_v
35: from ic_tran_cmp_vw1 where trans_id = trans_id_v;
36: end if;
37:
38: PKG_VAR_ITEM_ID_V := item_id_vi;
39: PKG_VAR_LOT_ID_V := lot_id_vi;

Line 112: from ic_tran_cmp_vw1

108: end if;
109:
110: select count(distinct to_char(item_id)||to_char(TRANS_DATE,'dd/mm/yy hh24:mi:ss'))
111: into ADJUST_BATCH_V
112: from ic_tran_cmp_vw1
113: where doc_id = BATCH_ID_VI
114: and doc_type = 'PROD'
115: and reason_code = fnd_profile.value('PMI$REASON_CODE_BTCH_ADJ');
116: