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 GME_MOBILE_TXN

Line 3924: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),

3920: BEGIN
3921: OPEN x_step_cursor FOR
3922: SELECT gbs.batchstep_no, glk.meaning,gbs.batchstep_id, gmo.oprn_no, gmo.oprn_vers, gbs.plan_step_qty,
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

Line 3926: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date

3922: SELECT gbs.batchstep_no, glk.meaning,gbs.batchstep_id, gmo.oprn_no, gmo.oprn_vers, gbs.plan_step_qty,
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

Line 3955: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING),

3951: BEGIN
3952: OPEN x_step_cursor FOR
3953: SELECT gbs.batchstep_no, glk.meaning,gbs.batchstep_id, gmo.oprn_no, gmo.oprn_vers, gbs.plan_step_qty,
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

Line 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,

3952: OPEN x_step_cursor FOR
3953: SELECT gbs.batchstep_no, glk.meaning,gbs.batchstep_id, gmo.oprn_no, gmo.oprn_vers, gbs.plan_step_qty,
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

Line 3957: TO_CHAR(gbs.plan_start_date, p_date_format||gme_mobile_txn.HOUR_MIN_SEC_FORMAT_STRING) plan_comlt_date

3953: SELECT gbs.batchstep_no, glk.meaning,gbs.batchstep_id, gmo.oprn_no, gmo.oprn_vers, gbs.plan_step_qty,
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