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.GME_MOBILE_LOVS dependencies on GMD_OPERATIONS

Line 874: gmd_operations o

870: o.oprn_desc,
871: s.batchstep_id
872: FROM gme_batch_steps s,
873: gme_batch_step_items i,
874: gmd_operations o
875: WHERE
876: i.batch_id = p_batch_id
877: AND s.batch_id = i.batch_id
878: AND i.batchstep_id = s.batchstep_id

Line 922: gmd_operations o,

918: o.oprn_desc,
919: s.batchstep_id
920: FROM gme_batch_steps s,
921: gme_batch_step_items i,
922: gmd_operations o,
923: gme_material_details d
924: WHERE
925: i.batch_id = p_batch_id
926: AND s.batch_id = i.batch_id

Line 973: gmd_operations o,

969: o.oprn_desc,
970: s.batchstep_id
971: FROM gme_batch_steps s,
972: gme_batch_step_items i,
973: gmd_operations o,
974: gme_material_details d
975: WHERE
976: i.batch_id = p_batch_id
977: AND s.batch_id = i.batch_id

Line 1024: gmd_operations o,

1020: o.oprn_desc,
1021: s.batchstep_id
1022: FROM gme_batch_steps s,
1023: gme_batch_step_items i,
1024: gmd_operations o,
1025: gme_material_details d
1026: WHERE
1027: i.batch_id = p_batch_id
1028: AND s.batch_id = i.batch_id

Line 2159: gmd_operations o

2155: o.oprn_desc,
2156: s.batchstep_id
2157: FROM gme_batch_header h,
2158: gme_batch_steps s,
2159: gmd_operations o
2160: WHERE h.batch_id = p_batch_id
2161: AND h.batch_type = 0
2162: AND h.batch_id = s.batch_id
2163: AND automatic_step_calculation = 0

Line 2174: gmd_operations o

2170: o.oprn_desc,
2171: s.batchstep_id
2172: FROM gme_batch_header h,
2173: gme_batch_steps s,
2174: gmd_operations o
2175: WHERE h.batch_id = p_batch_id
2176: AND h.batch_type = 0
2177: AND h.batch_id = s.batch_id
2178: AND automatic_step_calculation = 1

Line 3843: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk

3839: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3840: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3841: ' ' act_start_date,
3842: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3843: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3844: WHERE gbh.batch_id = p_batch_id
3845: AND gbh.batch_type = 0
3846: AND gbh.batch_id = gbs.batch_id
3847: AND gbs.step_status = 1

Line 3874: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk

3870: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3871: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3872: DECODE(gbs.actual_start_date,NULL,' ',TO_CHAR(gbs.actual_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING)) act_start_date,
3873: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3874: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3875: WHERE gbh.batch_id = p_batch_id
3876: AND gbh.batch_type = 0
3877: AND gbh.batch_id = gbs.batch_id
3878: AND gbs.step_status IN (1,2)