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.GMI_ALLOCATE_INVENTORY_PVT dependencies on IC_LOTS_MST

Line 69: l_lot_no IC_LOTS_MST.LOT_NO%TYPE :=0;

65: l_loct_onhand NUMBER;
66: l_loct_onhand2 NUMBER;
67: l_commit_qty NUMBER;
68: l_commit_qty2 NUMBER;
69: l_lot_no IC_LOTS_MST.LOT_NO%TYPE :=0;
70: l_sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE :=0;
71: l_loct_ctl NUMBER(2);
72: l_lot_id IC_LOTS_MST.LOT_ID%TYPE :=0;
73: l_lot_status IC_TRAN_PND.LOT_STATUS%TYPE;

Line 70: l_sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE :=0;

66: l_loct_onhand2 NUMBER;
67: l_commit_qty NUMBER;
68: l_commit_qty2 NUMBER;
69: l_lot_no IC_LOTS_MST.LOT_NO%TYPE :=0;
70: l_sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE :=0;
71: l_loct_ctl NUMBER(2);
72: l_lot_id IC_LOTS_MST.LOT_ID%TYPE :=0;
73: l_lot_status IC_TRAN_PND.LOT_STATUS%TYPE;
74: l_lot_created IC_LOTS_MST.LOT_CREATED%TYPE;

Line 72: l_lot_id IC_LOTS_MST.LOT_ID%TYPE :=0;

68: l_commit_qty2 NUMBER;
69: l_lot_no IC_LOTS_MST.LOT_NO%TYPE :=0;
70: l_sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE :=0;
71: l_loct_ctl NUMBER(2);
72: l_lot_id IC_LOTS_MST.LOT_ID%TYPE :=0;
73: l_lot_status IC_TRAN_PND.LOT_STATUS%TYPE;
74: l_lot_created IC_LOTS_MST.LOT_CREATED%TYPE;
75: l_location IC_TRAN_PND.LOCATION%TYPE;
76: l_expire_date IC_LOTS_MST.EXPIRE_DATE%TYPE;

Line 74: l_lot_created IC_LOTS_MST.LOT_CREATED%TYPE;

70: l_sublot_no IC_LOTS_MST.SUBLOT_NO%TYPE :=0;
71: l_loct_ctl NUMBER(2);
72: l_lot_id IC_LOTS_MST.LOT_ID%TYPE :=0;
73: l_lot_status IC_TRAN_PND.LOT_STATUS%TYPE;
74: l_lot_created IC_LOTS_MST.LOT_CREATED%TYPE;
75: l_location IC_TRAN_PND.LOCATION%TYPE;
76: l_expire_date IC_LOTS_MST.EXPIRE_DATE%TYPE;
77: l_qc_grade IC_LOTS_MST.QC_GRADE%TYPE;
78: l_shelf_date IC_TRAN_PND.TRANS_DATE%TYPE;

Line 76: l_expire_date IC_LOTS_MST.EXPIRE_DATE%TYPE;

72: l_lot_id IC_LOTS_MST.LOT_ID%TYPE :=0;
73: l_lot_status IC_TRAN_PND.LOT_STATUS%TYPE;
74: l_lot_created IC_LOTS_MST.LOT_CREATED%TYPE;
75: l_location IC_TRAN_PND.LOCATION%TYPE;
76: l_expire_date IC_LOTS_MST.EXPIRE_DATE%TYPE;
77: l_qc_grade IC_LOTS_MST.QC_GRADE%TYPE;
78: l_shelf_date IC_TRAN_PND.TRANS_DATE%TYPE;
79:
80: ll_shelf_date VARCHAR2(32);

Line 77: l_qc_grade IC_LOTS_MST.QC_GRADE%TYPE;

73: l_lot_status IC_TRAN_PND.LOT_STATUS%TYPE;
74: l_lot_created IC_LOTS_MST.LOT_CREATED%TYPE;
75: l_location IC_TRAN_PND.LOCATION%TYPE;
76: l_expire_date IC_LOTS_MST.EXPIRE_DATE%TYPE;
77: l_qc_grade IC_LOTS_MST.QC_GRADE%TYPE;
78: l_shelf_date IC_TRAN_PND.TRANS_DATE%TYPE;
79:
80: ll_shelf_date VARCHAR2(32);
81: l_from_expiration_date VARCHAR2(32);

Line 119: l_preferred_grade IC_LOTS_MST.QC_GRADE%TYPE;

115: l_schedule_ship_date DATE;
116: l_org_id NUMBER;
117: l_sold_to_org_id NUMBER;
118: l_ship_to_org_id NUMBER;
119: l_preferred_grade IC_LOTS_MST.QC_GRADE%TYPE;
120: l_message_data VARCHAR2(500);
121: l_alloc_all_lot_flag VARCHAR2(1);
122:
123: