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 GME_BATCH_HEADER

Line 34: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

30: bd.item_id,
31: '1',
32: count(*),
33: sysdate
34: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
35: where bh.batch_id = bd.batch_id
36: and line_type = 1
37: and bh.plant_CODE = og.ORGN_CODE
38: and og.CO_CODE = cl.CO_CODE

Line 72: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

68: bd.item_id,
69: '3',
70: count(*),
71: sysdate
72: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
73: where bh.batch_id = bd.batch_id
74: and line_type = 1
75: and bh.plant_CODE = og.ORGN_CODE
76: and og.CO_CODE = cl.CO_CODE

Line 111: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

107: bd.item_id,
108: '2',
109: count(*),
110: sysdate
111: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
112: where bh.batch_id = bd.batch_id
113: and bh.batch_status > 1
114: and line_type = 1
115: and bh.plant_CODE = og.ORGN_CODE

Line 150: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

146: bd.item_id,
147: '4',
148: count(*),
149: sysdate
150: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
151: where bh.batch_id = bd.batch_id
152: and bh.batch_status > 2
153: and line_type = 1
154: and bh.plant_CODE = og.ORGN_CODE

Line 189: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

185: bd.item_id,
186: '5',
187: count(*),
188: sysdate
189: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
190: where bh.batch_id = bd.batch_id
191: and bh.batch_status = 4
192: and line_type = 1
193: and bh.plant_CODE = og.ORGN_CODE

Line 229: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og

225: bd.item_id,
226: '6',
227: count(*),
228: sysdate
229: from gme_batch_header bh, gme_material_details bd, pmi_gl_calendar_v cl,sy_orgn_mst og
230: where bh.batch_id = bd.batch_id
231: and bh.batch_status = -1
232: and line_type = 1
233: and bh.plant_CODE = og.ORGN_CODE

Line 392: ACTUAL_START_DATE_V GME_BATCH_HEADER.ACTUAL_START_DATE%type;

388:
389: FUNCTION SCHD_WORK_HOUR(BATCH_ID_VI IN INTEGER, SCHEDULE_VI IN ps_schd_hdr.schedule%type)
390: RETURN NUMBER
391: is
392: ACTUAL_START_DATE_V GME_BATCH_HEADER.ACTUAL_START_DATE%type;
393: ACTUAL_CMPLT_DATE_V GME_BATCH_HEADER.ACTUAL_CMPLT_DATE%type;
394: NO_DAYS_V INTEGER := 0;
395: Count1_V INTEGER := 0;
396: Count2_V INTEGER := 0;

Line 393: ACTUAL_CMPLT_DATE_V GME_BATCH_HEADER.ACTUAL_CMPLT_DATE%type;

389: FUNCTION SCHD_WORK_HOUR(BATCH_ID_VI IN INTEGER, SCHEDULE_VI IN ps_schd_hdr.schedule%type)
390: RETURN NUMBER
391: is
392: ACTUAL_START_DATE_V GME_BATCH_HEADER.ACTUAL_START_DATE%type;
393: ACTUAL_CMPLT_DATE_V GME_BATCH_HEADER.ACTUAL_CMPLT_DATE%type;
394: NO_DAYS_V INTEGER := 0;
395: Count1_V INTEGER := 0;
396: Count2_V INTEGER := 0;
397: batch_time_v INTEGER := 0;

Line 398: PLANT_CODE_V1 GME_BATCH_HEADER.PLANT_CODE%type;

394: NO_DAYS_V INTEGER := 0;
395: Count1_V INTEGER := 0;
396: Count2_V INTEGER := 0;
397: batch_time_v INTEGER := 0;
398: PLANT_CODE_V1 GME_BATCH_HEADER.PLANT_CODE%type;
399:
400: SHIFT_START_V INTEGER := 0;
401: SHIFT_END_V INTEGER := 0;
402: SHIFT_DURATION_V INTEGER;

Line 411: PLANT_CODE_V GME_BATCH_HEADER.PLANT_CODE%type,

407: Batch_day_V1 DATE;
408:
409: CURSOR shop_cal_CUR(
410: SCHEDULE_V PS_SCHD_HDR.SCHEDULE%TYPE,
411: PLANT_CODE_V GME_BATCH_HEADER.PLANT_CODE%type,
412: Batch_day_V DATE )
413: IS
414: SELECT shift_start,shift_duration
415: FROM ps_schd_dtl sd, ps_schd_hdr sh,

Line 428: from gme_batch_header

424:
425: Begin
426: SELECT PLANT_CODE,ACTUAL_START_DATE,ACTUAL_CMPLT_DATE
427: into PLANT_CODE_V1,ACTUAL_START_DATE_V, ACTUAL_CMPLT_DATE_V
428: from gme_batch_header
429: where batch_id = batch_id_vi;
430:
431: select count(*) into count2_v
432: from ps_schd_dtl sd, ps_schd_hdr sh

Line 561: GME_BATCH_HEADER BtchHdr,

557: BtchDtl.PLAN_QTY,ItemMst.ITEM_UM)*pmi_common_pkg.PMICO_GET_COST(
558: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE))
559: into PLAN_ING_VALUE_V
560: FROM
561: GME_BATCH_HEADER BtchHdr,
562: GME_MATERIAL_DETAILS BtchDtl,
563: IC_ITEM_MST ItemMst
564: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
565: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID

Line 581: GME_BATCH_HEADER BtchHdr,

577: BtchDtl.ACTUAL_QTY,ItemMst.ITEM_UM)*pmi_common_pkg.PMICO_GET_COST(
578: BtchDtl.ITEM_ID,BtchHdr.WIP_WHSE_CODE,NULL,BtchHdr.ACTUAL_CMPLT_DATE))
579: into ACTUAL_ING_VALUE_V
580: FROM
581: GME_BATCH_HEADER BtchHdr,
582: GME_MATERIAL_DETAILS BtchDtl,
583: IC_ITEM_MST ItemMst
584: WHERE BtchHdr.BATCH_ID = BATCH_ID_VI
585: AND BtchHdr.BATCH_ID = BtchDtl.BATCH_ID