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.GMP_APS_WRITER dependencies on CR_RSRC_DTL

Line 499: CR_RSRC_DTL crd

495: FROM GME_BATCH_HEADER gbh,
496: GME_BATCH_STEPS gbs,
497: GME_BATCH_STEP_ACTIVITIES gba,
498: GME_BATCH_STEP_RESOURCES gbr,
499: CR_RSRC_DTL crd
500: WHERE gbh.batch_id = gbs.batch_id
501: AND gbs.batchstep_id = gba.batchstep_id
502: AND gbs.batchstep_id = gbr.batchstep_id
503: AND gba.batchstep_activity_id = gbr.batchstep_activity_id

Line 659: ||' cr_rsrc_dtl crd ' -- For R12.0

655: -- For R12.0
656: ||' FROM gme_batch_step_activities gsa, '
657: ||' gme_batch_steps gbs, '
658: ||' gme_batch_step_resources gsr, '
659: ||' cr_rsrc_dtl crd ' -- For R12.0
660: ||' WHERE '
661: ||' gsr.batch_id = gsa.batch_id '
662: ||' AND gsr.batchstep_activity_id = gsa.batchstep_activity_id '
663: ||' AND crd.resources = gsr.resources ' -- For R12.0

Line 714: ||' cr_rsrc_dtl crd, '

710: ||' gad.schedule_seq_num ) '
711: ||' - crd.delete_mark ) rsrc_count '
712: ||' FROM gmp_aps_output_dtl gad, '
713: ||' gmp_aps_output_tbl gao, '
714: ||' cr_rsrc_dtl crd, '
715: -- Sequence depdendency selection For R12.0
716: ||' ( SELECT operation_seq_num, parent_seq_num, schedule_seq_num, '
717: ||' wip_entity_id, resource_id_new , '
718: ||' TO_NUMBER(attribute1) sequence_dependent_usage, '

Line 1166: ||' cr_rsrc_dtl crd '

1162: ||' gad.completion_date, '
1163: ||' gad.resource_instance_id ' -- For R12.0
1164: ||' FROM gmp_aps_output_dtl gad, '
1165: ||' gmp_aps_output_tbl gao, '
1166: ||' cr_rsrc_dtl crd '
1167: ||' WHERE '
1168: ||' gad.load_type in (4,9) '
1169: ||' AND gad.parent_header_id = gao.header_id '
1170: ||' AND gad.group_id = gao.process_id '

Line 1684: cr_rsrc_dtl crd,

1680: gsr.plan_cmplt_date,
1681: crd.schedule_ind
1682: FROM
1683: gme_batch_step_resources gsr,
1684: cr_rsrc_dtl crd,
1685: mtl_units_of_measure u1,
1686: mtl_units_of_measure u2
1687: WHERE
1688: gsr.batchstep_activity_id = v_activity_id

Line 2407: ||' cr_rsrc_dtl crd '

2403: ||' nvl((SELECT SUM(DECODE(sign(g1.gen_lupd '
2404: ||' - trunc(gor.last_update_date)), 1,1,0,1,-1,-600))'
2405: ||' FROM'
2406: ||' gmd_operation_resources gor, '
2407: ||' cr_rsrc_dtl crd '
2408: ||' WHERE'
2409: ||' goa.oprn_line_id = gor.oprn_line_id '
2410: ||' AND crd.organization_id = :porgid ' -- For R12.0
2411: ||' AND crd.resources = gor.resources ' -- For R12.0

Line 2886: cr_rsrc_dtl crd

2882: gad.created_by
2883: FROM gmp_aps_output_dtl gad,
2884: gmp_aps_output_tbl gao,
2885: gme_batch_steps gbs,
2886: cr_rsrc_dtl crd
2887: WHERE gad.parent_header_id = gao.header_id
2888: AND gad.group_id = gao.process_id
2889: AND gad.organization_id = gao.organization_id
2890: AND gad.wip_entity_id = pbatch_id