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 901: gmd_operations o

897: o.oprn_desc,
898: s.batchstep_id
899: FROM gme_batch_steps s,
900: gme_batch_step_items i,
901: gmd_operations o
902: WHERE
903: i.batch_id = p_batch_id
904: AND s.batch_id = i.batch_id
905: AND i.batchstep_id = s.batchstep_id

Line 949: gmd_operations o,

945: o.oprn_desc,
946: s.batchstep_id
947: FROM gme_batch_steps s,
948: gme_batch_step_items i,
949: gmd_operations o,
950: gme_material_details d
951: WHERE
952: i.batch_id = p_batch_id
953: AND s.batch_id = i.batch_id

Line 1000: gmd_operations o,

996: o.oprn_desc,
997: s.batchstep_id
998: FROM gme_batch_steps s,
999: gme_batch_step_items i,
1000: gmd_operations o,
1001: gme_material_details d
1002: WHERE
1003: i.batch_id = p_batch_id
1004: AND s.batch_id = i.batch_id

Line 1051: gmd_operations o,

1047: o.oprn_desc,
1048: s.batchstep_id
1049: FROM gme_batch_steps s,
1050: gme_batch_step_items i,
1051: gmd_operations o,
1052: gme_material_details d
1053: WHERE
1054: i.batch_id = p_batch_id
1055: AND s.batch_id = i.batch_id

Line 2186: gmd_operations o

2182: o.oprn_desc,
2183: s.batchstep_id
2184: FROM gme_batch_header h,
2185: gme_batch_steps s,
2186: gmd_operations o
2187: WHERE h.batch_id = p_batch_id
2188: AND h.batch_type = 0
2189: AND h.batch_id = s.batch_id
2190: AND automatic_step_calculation = 0

Line 2201: gmd_operations o

2197: o.oprn_desc,
2198: s.batchstep_id
2199: FROM gme_batch_header h,
2200: gme_batch_steps s,
2201: gmd_operations o
2202: WHERE h.batch_id = p_batch_id
2203: AND h.batch_type = 0
2204: AND h.batch_id = s.batch_id
2205: AND automatic_step_calculation = 1

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

3923: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3924: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3925: ' ' act_start_date,
3926: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3927: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3928: WHERE gbh.batch_id = p_batch_id
3929: AND gbh.batch_type = 0
3930: AND gbh.batch_id = gbs.batch_id
3931: AND gbs.step_status = 1

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

3954: TO_NUMBER(NULL) act_step_qty, gbs.step_qty_um,
3955: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),
3956: 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,
3957: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date
3958: FROM gme_batch_header gbh, gme_batch_steps gbs, gmd_operations gmo, gem_lookups glk
3959: WHERE gbh.batch_id = p_batch_id
3960: AND gbh.batch_type = 0
3961: AND gbh.batch_id = gbs.batch_id
3962: AND gbs.step_status IN (1,2)