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.CSD_REPAIRS_UTIL dependencies on WIP_DISCRETE_JOBS

Line 751: FROM csd_repair_job_xref crx, wip_discrete_jobs wdj

747:
748: -- Cursor to check open wip jobs for the repair order
749: CURSOR wipjob_cur IS
750: SELECT 'x' /* crx.repair_job_xref_id */
751: FROM csd_repair_job_xref crx, wip_discrete_jobs wdj
752: WHERE crx.repair_line_id = p_repair_line_id
753: AND crx.wip_entity_id = wdj.wip_entity_id
754: AND wdj.status_type NOT IN (4,5,7,12)
755: /* 4: Complete,5: Complete-No charges,7: Cancelled,12: Closed */

Line 2463: from wip_discrete_jobs wdj

2459: l_task_id(i) := l_task_id(i-1);
2460: else
2461: select wdj.material_account, wdj.material_variance_account, wdj.project_id, wdj.task_id
2462: into l_material_account(i),l_material_variance_account(i), l_project_id(i), l_task_id(i)
2463: from wip_discrete_jobs wdj
2464: where wdj.wip_entity_id = l_wip_entity_id_tbl(i)
2465: and wdj.organization_id = p_organization_id;
2466: end if;
2467:

Line 3057: csd_repair_job_xref crj, wip_discrete_jobs wdj

3053: CURSOR c_all_mtl_transactions(p_repair_line_id NUMBER)
3054: IS
3055: SELECT mmt.reason_id,mmt.inventory_item_id,wdj.primary_item_id,wro.organization_id
3056: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
3057: csd_repair_job_xref crj, wip_discrete_jobs wdj
3058: WHERE crj.repair_line_id = p_repair_line_id
3059: AND crj.wip_entity_id = wro.wip_entity_id
3060: AND wro.operation_seq_num = mmt.operation_seq_num
3061: AND wro.organization_id = mmt.organization_id