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 512: CR_RSRC_DTL crd

508: FROM GME_BATCH_HEADER gbh,
509: GME_BATCH_STEPS gbs,
510: GME_BATCH_STEP_ACTIVITIES gba,
511: GME_BATCH_STEP_RESOURCES gbr,
512: CR_RSRC_DTL crd
513: WHERE gbh.batch_id = gbs.batch_id
514: AND gbs.batchstep_id = gba.batchstep_id
515: AND gbs.batchstep_id = gbr.batchstep_id
516: AND gba.batchstep_activity_id = gbr.batchstep_activity_id

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

669: -- For R12.0
670: ||' FROM gme_batch_step_activities gsa, '
671: ||' gme_batch_steps gbs, '
672: ||' gme_batch_step_resources gsr, '
673: ||' cr_rsrc_dtl crd ' -- For R12.0
674: ||' WHERE '
675: ||' gsr.batch_id = gsa.batch_id '
676: ||' AND gsr.batchstep_activity_id = gsa.batchstep_activity_id '
677: ||' AND crd.resources = gsr.resources ' -- For R12.0

Line 732: ||' cr_rsrc_dtl crd, '

728: ||' - crd.delete_mark ) rsrc_count, '
729: ||' gao.inventory_item_id ' -- Bug: 8616967 Vpedarla
730: ||' FROM gmp_aps_output_dtl gad, '
731: ||' gmp_aps_output_tbl gao, '
732: ||' cr_rsrc_dtl crd, '
733: -- Sequence depdendency selection For R12.0
734: ||' ( SELECT operation_seq_num, parent_seq_num, schedule_seq_num, '
735: ||' wip_entity_id, resource_id_new , '
736: ||' TO_NUMBER(attribute1) sequence_dependent_usage, '

Line 1220: ||' cr_rsrc_dtl crd , '

1216: ||' gme.USAGE_UM , ' --Bug: 8616967 Vpedarla
1217: ||' gao.inventory_item_id ' --Bug: 8616967 Vpedarla
1218: ||' FROM gmp_aps_output_dtl gad, '
1219: ||' gmp_aps_output_tbl gao, '
1220: ||' cr_rsrc_dtl crd , '
1221: ||' gme_batch_step_resources gme ' --Bug: 8616967 Vpedarla
1222: ||' WHERE '
1223: ||' gad.load_type in (4,9) '
1224: ||' AND gad.parent_header_id = gao.header_id '

Line 1790: cr_rsrc_dtl crd,

1786: gsr.plan_cmplt_date,
1787: crd.schedule_ind
1788: FROM
1789: gme_batch_step_resources gsr,
1790: cr_rsrc_dtl crd,
1791: mtl_units_of_measure u1,
1792: mtl_units_of_measure u2
1793: WHERE
1794: gsr.batchstep_activity_id = v_activity_id

Line 2506: ||' cr_rsrc_dtl crd '

2502: ||' AND header_id = :phdr1) '
2503: ||' - trunc(gor.last_update_date)), 1,1,0,1,-1,-600))'
2504: ||' FROM'
2505: ||' gmd_operation_resources gor, '
2506: ||' cr_rsrc_dtl crd '
2507: ||' WHERE'
2508: ||' goa.oprn_line_id = gor.oprn_line_id '
2509: ||' AND crd.organization_id = :porgid ' -- For R12.0
2510: ||' AND crd.resources = gor.resources ' -- For R12.0

Line 2989: cr_rsrc_dtl crd

2985: gad.created_by
2986: FROM gmp_aps_output_dtl gad,
2987: gmp_aps_output_tbl gao,
2988: gme_batch_steps gbs,
2989: cr_rsrc_dtl crd
2990: WHERE gad.parent_header_id = gao.header_id
2991: AND gad.group_id = gao.process_id
2992: AND gad.organization_id = gao.organization_id
2993: AND gad.wip_entity_id = pbatch_id