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 WIP_DISCRETE_JOBS

Line 1823: from wip_discrete_jobs wdj, mtl_system_items_kfv msi

1819: transaction_quantity,
1820: wdj.completion_subinventory, wdj.completion_locator_id,
1821: msi.primary_uom_code, msi.revision_qty_control_code,
1822: msi.SERIAL_NUMBER_CONTROL_CODE, msi.LOT_CONTROL_CODE
1823: from wip_discrete_jobs wdj, mtl_system_items_kfv msi
1824: where wdj.wip_entity_id = p_comp_job_dtls_rec.wip_entity_id and
1825: wdj.primary_item_id = msi.inventory_item_id and
1826: wdj.organization_id = msi.organization_id;
1827:

Line 4696: SELECT start_quantity from wip_discrete_jobs where

4692: l_op_exists VARCHAR2(10);
4693: l_op_dtls_tbl OP_DTLS_TBL_TYPE;
4694:
4695: CURSOR get_job_quantity ( p_wip_entity_id NUMBER ) IS
4696: SELECT start_quantity from wip_discrete_jobs where
4697: wip_entity_id = p_wip_entity_id ;
4698:
4699: CURSOR get_operation_exists(p_wip_entity_id NUMBER ) IS
4700: SELECT 'exists'

Line 5495: SELECT start_quantity from wip_discrete_jobs where

5491: l_resource_seq_num NUMBER;
5492:
5493:
5494: CURSOR get_job_quantity ( p_wip_entity_id NUMBER ) IS
5495: SELECT start_quantity from wip_discrete_jobs where
5496: wip_entity_id = p_wip_entity_id ;
5497:
5498: -- swai: bug 7017062 nvl the max(resource_seq_num)
5499: cursor get_next_resource_seq_num ( p_wip_entity_id NUMBER,

Line 8062: WIP_DISCRETE_JOBS WDJ,

8058: WIP_REQUIREMENT_OPERATIONS WRO,
8059: MTL_SYSTEM_ITEMS_KFV MSIK,
8060: WIP_ENTITIES WE,
8061: CSD_WIP_TRANSACTION_DETAILS CWTD,
8062: WIP_DISCRETE_JOBS WDJ,
8063: WIP_OPERATIONS WO,
8064: MTL_SERIAL_NUMBERS MSN,
8065: MTL_TRANSACTION_REASONS MTR
8066: WHERE

Line 8283: WIP_DISCRETE_JOBS wdj,

8279: WIP_ENTITIES WE,
8280: CSD_WIP_TRANSACTION_DETAILS WTD,
8281: BOM_RESOURCES BR,
8282: wip_operations wo,
8283: WIP_DISCRETE_JOBS wdj,
8284: per_all_people_f papf,
8285: MTL_PARAMETERS MP
8286: WHERE CRJX.wip_entity_id = p_wip_entity_id
8287: AND WO.operation_seq_num = p_operation_seq_num

Line 8457: wip_discrete_jobs wdj,

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,
8459: mfg_lookups ml,
8460: mtl_system_items_kfv msik,
8461: csd_service_codes_vl cscv,

Line 8719: WIP_DISCRETE_JOBS wdj,

8715: WIP_ENTITIES WE,
8716: CSD_WIP_TRANSACTION_DETAILS WTD,
8717: BOM_RESOURCES BR,
8718: wip_operations wo,
8719: WIP_DISCRETE_JOBS wdj,
8720: per_all_people_f papf,
8721: MTL_PARAMETERS MP
8722: WHERE CRJX.wip_entity_id = p_wip_entity_id
8723: AND WO.operation_seq_num = p_operation_seq_num

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

Line 10134: csd_wip_transaction_details cwt,wip_discrete_jobs wdj

10130: ELSE
10131: OPEN l_all_jobs FOR
10132: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10133: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10134: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10135: WHERE cwt.wip_entity_id = wro.wip_entity_id
10136: AND cwt.inventory_item_id = wro.inventory_item_id
10137: AND cwt.operation_seq_num = wro.operation_seq_num
10138: AND wro.inventory_item_id = mmt.inventory_item_id

Line 10171: csd_wip_transaction_details cwt,wip_discrete_jobs wdj

10167: THEN
10168: OPEN l_all_jobs FOR
10169: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10170: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10171: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10172: WHERE cwt.wip_entity_id = wro.wip_entity_id
10173: AND cwt.inventory_item_id = wro.inventory_item_id
10174: AND cwt.operation_seq_num = wro.operation_seq_num
10175: AND wro.inventory_item_id = mmt.inventory_item_id

Line 10205: csd_wip_transaction_details cwt,wip_discrete_jobs wdj

10201: ELSE
10202: OPEN l_all_jobs FOR
10203: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10204: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10205: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10206: WHERE cwt.wip_entity_id = wro.wip_entity_id
10207: AND cwt.inventory_item_id = wro.inventory_item_id
10208: AND cwt.operation_seq_num = wro.operation_seq_num
10209: AND wro.inventory_item_id = mmt.inventory_item_id