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_HV_WIP_JOB_PVT dependencies on CSD_REPAIR_JOB_XREF

Line 1510: FROM csd_repair_job_xref crj,wip_requirement_operations wro

1506: fnd_global.user_id created_by,
1507: sysdate creation_date,
1508: fnd_global.user_id last_updated_by,
1509: sysdate last_update_date
1510: FROM csd_repair_job_xref crj,wip_requirement_operations wro
1511: WHERE crj.wip_entity_id = wro.wip_entity_id
1512: AND crj.repair_line_id = p_repair_line_id
1513: AND NOT EXISTS (SELECT 'exists'
1514: FROM csd_wip_transaction_details cwt

Line 1574: FROM wip_requirement_operations wro,csd_repair_job_xref crj

1570: fnd_global.user_id created_by,
1571: sysdate creation_date,
1572: fnd_global.user_id last_updated_by,
1573: sysdate last_update_date
1574: FROM wip_requirement_operations wro,csd_repair_job_xref crj
1575: WHERE crj.wip_entity_id = wro.wip_entity_id
1576: AND NOT EXISTS (SELECT 'exists'
1577: FROM csd_wip_transaction_details cwt
1578: WHERE cwt.wip_entity_id = wro.wip_entity_id

Line 6647: from csd_repair_job_xref crj,

6643: -- the RO item as a material. Must compare we.wip_entity_id since
6644: -- crj.wip_entity_id may be null (until wip_update is done).
6645: select count(*)
6646: into l_num_other_jobs
6647: from csd_repair_job_xref crj,
6648: wip_entities we
6649: where crj.job_name = we.wip_entity_name
6650: and crj.organization_id = we.organization_id
6651: and crj.repair_line_id = p_repair_line_id

Line 6816: -- call procedures to insert a row in csd_repair_job_xref

6812:
6813: -- END IF;
6814:
6815:
6816: -- call procedures to insert a row in csd_repair_job_xref
6817: -- and csd_repair_history tables for the job created.
6818:
6819: L_user_id := fnd_global.user_id;
6820:

Line 7530: from csd_repair_job_xref crj,

7526: -- the RO item as a material. Must compare we.wip_entity_id since
7527: -- crj.wip_entity_id may be null (until wip_update is done).
7528: select count(*)
7529: into l_num_other_jobs
7530: from csd_repair_job_xref crj,
7531: wip_entities we
7532: where crj.job_name = we.wip_entity_name
7533: and crj.organization_id = we.organization_id
7534: and crj.repair_line_id = p_repair_line_id

Line 7687: -- call procedures to insert a row in csd_repair_job_xref

7683: End if;
7684:
7685: -- dbms_output.put_line('After createOneJob');
7686:
7687: -- call procedures to insert a row in csd_repair_job_xref
7688: -- and csd_repair_history tables for the job created.
7689:
7690: l_user_id := fnd_global.user_id;
7691:

Line 8057: CSD_REPAIR_JOB_XREF CRJX,

8053: , CWTD.attribute14
8054: , CWTD.attribute15
8055: , CWTD.create_ro_flag --bug#13698799 auto create ro, parent ro
8056: FROM
8057: CSD_REPAIR_JOB_XREF CRJX,
8058: WIP_REQUIREMENT_OPERATIONS WRO,
8059: MTL_SYSTEM_ITEMS_KFV MSIK,
8060: WIP_ENTITIES WE,
8061: CSD_WIP_TRANSACTION_DETAILS CWTD,

Line 8277: FROM CSD_REPAIR_JOB_XREF CRJX,

8273: , WTD.attribute12
8274: , WTD.attribute13
8275: , WTD.attribute14
8276: , WTD.attribute15
8277: FROM CSD_REPAIR_JOB_XREF CRJX,
8278: WIP_OPERATION_RESOURCES WOR,
8279: WIP_ENTITIES WE,
8280: CSD_WIP_TRANSACTION_DETAILS WTD,
8281: BOM_RESOURCES BR,

Line 8454: FROM CSD_REPAIR_JOB_XREF CRJX,

8450: wo.next_operation_seq_num,
8451: wo.quantity_in_queue, -- transaction_quantity
8452: msik.primary_uom_code, -- transaction_uom
8453: crjx.wip_entity_id
8454: FROM CSD_REPAIR_JOB_XREF CRJX,
8455: WIP_OPERATIONS WO,
8456: BOM_DEPARTMENTS BD,
8457: wip_discrete_jobs wdj,
8458: wip_entities we,

Line 8713: FROM CSD_REPAIR_JOB_XREF CRJX,

8709: papf.employee_number employee_num,
8710: wor.basis_type basis_type,
8711: wtd.object_version_number,
8712: 'N' new_row
8713: FROM CSD_REPAIR_JOB_XREF CRJX,
8714: WIP_OPERATION_RESOURCES WOR,
8715: WIP_ENTITIES WE,
8716: CSD_WIP_TRANSACTION_DETAILS WTD,
8717: BOM_RESOURCES BR,

Line 9436: from csd_repair_job_xref xref, csd_repairs csd

9432: ) RETURN VARCHAR2
9433: IS
9434: cursor c_get_ro_status is
9435: select csd.status
9436: from csd_repair_job_xref xref, csd_repairs csd
9437: where xref.wip_entity_id = p_wip_entity_id
9438: and xref.repair_line_id = csd.repair_line_id;
9439:
9440: cursor c_time_clock_entries_exist is

Line 10028: csd_wip_transaction_details cwt,csd_repair_job_xref crj

10024:
10025: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10026: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
10027: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10028: csd_wip_transaction_details cwt,csd_repair_job_xref crj
10029: WHERE crj.repair_line_id = p_repair_line_id
10030: AND cwt.wip_entity_id = crj.wip_entity_id
10031: AND cwt.wip_entity_id = wro.wip_entity_id
10032: AND cwt.inventory_item_id = wro.inventory_item_id

Line 10061: csd_wip_transaction_details cwt,csd_repair_job_xref crj,wip_discrete_jobs wdj

10057:
10058: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10059: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
10060: from mtl_material_transactions mmt, wip_requirement_operations wro,
10061: csd_wip_transaction_details cwt,csd_repair_job_xref crj,wip_discrete_jobs wdj
10062: WHERE crj.repair_line_id = p_repair_line_id
10063: AND cwt.wip_entity_id = crj.wip_entity_id
10064: AND cwt.wip_entity_id = wro.wip_entity_id
10065: AND cwt.inventory_item_id = wro.inventory_item_id