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.

[Home] [Help]

APPS.OPI_EDW_OPM_PRD_PKG dependencies on PM_BTCH_HDR

Line 138: PM_BTCH_HDR BtchHdr,

134: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,
135: BtchHdr.ACTUAL_CMPLT_DATE))
136: into INGREDIENT_VALUE_V
137: FROM
138: PM_BTCH_HDR BtchHdr,
139: PM_MATL_DTL BtchDtl,
140: IC_ITEM_MST ItemMst
141: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
142: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID

Line 152: PM_BTCH_HDR BtchHdr,

148: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
149: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE)
150: into L_ITEM_VALUE
151: FROM
152: PM_BTCH_HDR BtchHdr,
153: PM_MATL_DTL BtchDtl,
154: IC_ITEM_MST ItemMst
155: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
156: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID

Line 171: PM_BTCH_HDR BtchHdr,

167: 4,BtchHdr.ACTUAL_CMPLT_DATE,
168: BtchHdr.EXPCT_CMPLT_DATE)))
169: into L_TOTAL_BATCH_OUT_VALUE
170: FROM
171: PM_BTCH_HDR BtchHdr,
172: PM_MATL_DTL BtchDtl,
173: IC_ITEM_MST ItemMst
174: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
175: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID

Line 192: PM_BTCH_HDR BtchHdr,

188: 4,BtchHdr.ACTUAL_CMPLT_DATE,
189: BtchHdr.EXPCT_CMPLT_DATE)))
190: into INGREDIENT_VALUE_V
191: FROM
192: PM_BTCH_HDR BtchHdr,
193: PM_MATL_DTL BtchDtl,
194: IC_ITEM_MST ItemMst
195: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
196: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID

Line 213: PM_BTCH_HDR BtchHdr,

209: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*OPI_OPM_COMMON_PKG.OPMCO_GET_COST(
210: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE))
211: into BYPRODUCT_VALUE_V
212: FROM
213: PM_BTCH_HDR BtchHdr,
214: PM_MATL_DTL BtchDtl,
215: IC_ITEM_MST ItemMst
216: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
217: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID

Line 229: PM_BTCH_HDR BtchHdr,

225: 4,BtchHdr.ACTUAL_CMPLT_DATE,
226: BtchHdr.EXPCT_CMPLT_DATE)))
227: into BYPRODUCT_VALUE_V
228: FROM
229: PM_BTCH_HDR BtchHdr,
230: PM_MATL_DTL BtchDtl,
231: IC_ITEM_MST ItemMst
232: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
233: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID

Line 244: START_DATE_V PM_BTCH_HDR.ACTUAL_START_DATE%type;

240:
241:
242: FUNCTION SCHD_WORK_DAYS(BATCH_ID_VI IN INTEGER , START_DATE IN DATE, CMPLT_DATE IN DATE) RETURN NUMBER
243: is
244: START_DATE_V PM_BTCH_HDR.ACTUAL_START_DATE%type;
245: CMPLT_DATE_V PM_BTCH_HDR.ACTUAL_CMPLT_DATE%type;
246: NO_DAYS_V INTEGER := 0;
247: Count1_V INTEGER := 0;
248: Count2_V INTEGER := 0;

Line 245: CMPLT_DATE_V PM_BTCH_HDR.ACTUAL_CMPLT_DATE%type;

241:
242: FUNCTION SCHD_WORK_DAYS(BATCH_ID_VI IN INTEGER , START_DATE IN DATE, CMPLT_DATE IN DATE) RETURN NUMBER
243: is
244: START_DATE_V PM_BTCH_HDR.ACTUAL_START_DATE%type;
245: CMPLT_DATE_V PM_BTCH_HDR.ACTUAL_CMPLT_DATE%type;
246: NO_DAYS_V INTEGER := 0;
247: Count1_V INTEGER := 0;
248: Count2_V INTEGER := 0;
249: batch_time_v INTEGER := 0;

Line 250: PLANT_CODE_V1 PM_BTCH_HDR.PLANT_CODE%type;

246: NO_DAYS_V INTEGER := 0;
247: Count1_V INTEGER := 0;
248: Count2_V INTEGER := 0;
249: batch_time_v INTEGER := 0;
250: PLANT_CODE_V1 PM_BTCH_HDR.PLANT_CODE%type;
251: SCHEDULE_VI ps_schd_hdr.schedule%type;
252: SHIFT_START_V INTEGER := 0;
253: SHIFT_END_V INTEGER := 0;
254: SHIFT_DURATION_V INTEGER;

Line 264: PLANT_CODE_V PM_BTCH_HDR.PLANT_CODE%type,

260: Batch_day_V1 DATE;
261:
262: CURSOR shop_cal_CUR(
263: SCHEDULE_V PS_SCHD_HDR.SCHEDULE%TYPE,
264: PLANT_CODE_V PM_BTCH_HDR.PLANT_CODE%type,
265: Batch_day_V DATE )
266: IS
267: SELECT shift_start,shift_duration
268: FROM ps_schd_dtl sd, ps_schd_hdr sh,

Line 281: from pm_btch_hdr

277:
278: Begin
279: SELECT PLANT_CODE
280: into PLANT_CODE_V1
281: from pm_btch_hdr
282: where batch_id = batch_id_vi;
283: /* Assign the Parameters */
284: START_DATE_V:=START_DATE;
285: CMPLT_DATE_V:=CMPLT_DATE;