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_PRODUCTION_SUM dependencies on IC_TRAN_CMP

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

258:
259: FUNCTION FIND_PROD_GRADE(TRANS_ID_VI IN INTEGER,ITEM_ID_VI IN INTEGER,LOT_ID_VI IN INTEGER)
260: RETURN VARCHAR2
261: IS
262: TRANS_ID_V ic_TRAN_CMP.TRANS_id%TYPE := NULL;
263: QC_GRADE_V ic_TRAN_CMP.QC_GRADE%TYPE := NULL;
264:
265: CURSOR GRADE_CHANGE_TRAN_CUR(
266: ITEM_ID_V ic_item_mst.item_id%TYPE,

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

259: FUNCTION FIND_PROD_GRADE(TRANS_ID_VI IN INTEGER,ITEM_ID_VI IN INTEGER,LOT_ID_VI IN INTEGER)
260: RETURN VARCHAR2
261: IS
262: TRANS_ID_V ic_TRAN_CMP.TRANS_id%TYPE := NULL;
263: QC_GRADE_V ic_TRAN_CMP.QC_GRADE%TYPE := NULL;
264:
265: CURSOR GRADE_CHANGE_TRAN_CUR(
266: ITEM_ID_V ic_item_mst.item_id%TYPE,
267: LOT_ID_V ic_lots_mst.lot_id%TYPE )

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

265: CURSOR GRADE_CHANGE_TRAN_CUR(
266: ITEM_ID_V ic_item_mst.item_id%TYPE,
267: LOT_ID_V ic_lots_mst.lot_id%TYPE )
268: IS
269: SELECT nvl(max(trans_id),0) from ic_tran_cmp_vw1
270: where item_id = item_id_v
271: and lot_id = lot_id_v
272: and doc_type = 'GRDI'
273: and reason_code = fnd_profile.value('PMI$REASON_CODE');

Line 287: from ic_tran_cmp_vw1 where trans_id = trans_id_vi;

283:
284: FETCH GRADE_CHANGE_TRAN_CUR INTO trans_id_v;
285: IF trans_id_v = 0 THEN
286: SELECT QC_GRADE into qc_grade_v
287: from ic_tran_cmp_vw1 where trans_id = trans_id_vi;
288: else
289: SELECT QC_GRADE into qc_grade_v
290: from ic_tran_cmp_vw1 where trans_id = trans_id_v;
291: end if;

Line 290: from ic_tran_cmp_vw1 where trans_id = trans_id_v;

286: SELECT QC_GRADE into qc_grade_v
287: from ic_tran_cmp_vw1 where trans_id = trans_id_vi;
288: else
289: SELECT QC_GRADE into qc_grade_v
290: from ic_tran_cmp_vw1 where trans_id = trans_id_v;
291: end if;
292:
293: PKG_VAR_ITEM_ID_V := item_id_vi;
294: PKG_VAR_LOT_ID_V := lot_id_vi;

Line 378: from ic_tran_cmp_vw1

374: end if;
375:
376: select count(distinct to_char(item_id)||to_char(TRANS_DATE,'dd/mm/yy hh24:mi:ss'))
377: into ADJUST_BATCH_V
378: from ic_tran_cmp_vw1
379: where doc_id = BATCH_ID_VI
380: and doc_type = 'PROD'
381: and reason_code = fnd_profile.value('PMI$REASON_CODE_BTCH_ADJ');
382: