DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on GME_RESOURCE_TXNS

Line 3815: FROM gmp_resource_instances i, gme_resource_txns_gtmp t

3811: , p_instance IN VARCHAR2) IS
3812: BEGIN
3813: OPEN x_resource_cursor FOR
3814: SELECT i.instance_number, i.instance_id
3815: FROM gmp_resource_instances i, gme_resource_txns_gtmp t
3816: WHERE t.doc_id = p_batch_id
3817: AND t.line_id = p_batchstep_resource_id
3818: AND t.start_date = t.end_date
3819: AND action_code NOT IN ('REVS', 'REVL')

Line 3972: gme_resource_txns_gtmp t,

3968: FROM gme_batch_steps s,
3969: gme_batch_step_activities a,
3970: gme_batch_step_resources r,
3971: gmp_resource_instances i,
3972: gme_resource_txns_gtmp t,
3973: gme_resource_txns rt,
3974: fnd_user u
3975: WHERE
3976: t.doc_id = p_batch_id

Line 3973: gme_resource_txns rt,

3969: gme_batch_step_activities a,
3970: gme_batch_step_resources r,
3971: gmp_resource_instances i,
3972: gme_resource_txns_gtmp t,
3973: gme_resource_txns rt,
3974: fnd_user u
3975: WHERE
3976: t.doc_id = p_batch_id
3977: AND t.line_id = r.batchstep_resource_id