APPS.EAM_WORKORDERREP_PVT dependencies on WIP_DISCRETE_JOBS

Line 409: wip_discrete_jobs wdj,

405: CSI_COUNTERS_B CBS,
406: CSI_COUNTER_READINGS CCR1,
407: CSI_COUNTER_READINGS CCR2,
408: csi_item_instances cii,
409: wip_discrete_jobs wdj,
410: (
411: SELECT
412: *
413: FROM csi_counter_associations

Line 519: wip_discrete_jobs wdj,

515: msik.primary_uom_code as "UOM",
516: lu.meaning as "SUPPLYTYPE")) AssetBom
517: from bom_inventory_components bic,
518: mtl_system_items_kfv msik,
519: wip_discrete_jobs wdj,
520: csi_item_instances cii,
521: bom_bill_of_materials bbom,
522: mfg_lookups lu
523: where bic.effectivity_date <= sysdate

Line 550: wip_discrete_jobs wdj,

546: msik.primary_uom_code as "UOM",
547: lu.meaning as "SUPPLYTYPE")) AssetBom
548: from bom_inventory_components bic,
549: mtl_system_items_kfv msik,
550: wip_discrete_jobs wdj,
551: bom_bill_of_materials bbom,
552: mfg_lookups lu
553: where bic.effectivity_date <= sysdate
554: and (bic.disable_date >= sysdate or

Line 663: wip_discrete_jobs wdj ,

659: and ewp1.PERMIT_ID not in (
660: SELECT permit.permit_id
661: FROM eam_work_permits permit,
662: eam_safety_associations esa ,
663: wip_discrete_jobs wdj ,
664: eam_permit_statuses_vl epsv
665: WHERE esa.target_ref_id=wdj.wip_entity_id
666: AND esa.source_id =permit.permit_id
667: AND esa.association_type =3

Line 705: wip_discrete_jobs wdj ,

701: ml2.meaning AS isolation_type
702: FROM
703: eam_work_clearances ewc ,
704: eam_safety_associations esa ,
705: wip_discrete_jobs wdj ,
706: mfg_lookups ml1 ,
707: mfg_lookups ml2 ,
708: EAM_WORK_CLEARANCE_STATUSES_VL ewsv,
709: eam_isolations iso

Line 743: wip_discrete_jobs wdj1

739: mfg_lookups ml3 ,
740: mfg_lookups ml4 ,
741: eam_work_clearance_statuses_vl ewsv1,
742: eam_isolations iso1 ,
743: wip_discrete_jobs wdj1
744: WHERE esa2.source_id =permit.permit_id
745: AND esa2.target_ref_id =ewc1.work_clearance_id
746: AND esa2.association_type =2
747: AND esa1.target_ref_id =wdj1.wip_entity_id

Line 761: wip_discrete_jobs wdj

757: AND ewc1.work_clearance_id NOT IN
758: (SELECT ewc.WORK_CLEARANCE_ID
759: FROM eam_work_clearances ewc,
760: eam_safety_associations esa ,
761: wip_discrete_jobs wdj
762: WHERE esa.target_ref_id=wdj.wip_entity_id
763: AND esa.source_id =ewc.WORK_CLEARANCE_ID
764: AND esa.association_type =4
765: AND wdj.organization_id = esa.organization_id

Line 778: from wip_discrete_jobs wdj

774: for i in p_wip_entity_id.FIRST..p_wip_entity_id.LAST
775: loop
776:
777: select wdj.organization_id into l_org_id
778: from wip_discrete_jobs wdj
779: where wdj.wip_entity_id=p_wip_entity_id(i);
780:
781: --begin changes for FP 7493388 (base bug 7005666)
782:

Line 784: from wip_discrete_jobs wdj

780:
781: --begin changes for FP 7493388 (base bug 7005666)
782:
783: select Nvl(wdj.ASSET_NUMBER,wdj.REBUILD_SERIAL_NUMBER),Nvl(wdj.ASSET_GROUP_ID,REBUILD_ITEM_ID) into l_serial_number ,l_inventory_id
784: from wip_discrete_jobs wdj
785: where wdj.wip_entity_id=p_wip_entity_id(i);
786:
787:
788: SELECT nvl(instance_number,'hghg') into l_instance_number

Line 1000: from wip_discrete_jobs wdj,

996: select we.wip_entity_name,
997: wdj.organization_id,
998: msi.concatenated_segments,
999: cii.instance_number,cii.serial_number into l_wip_entity_name,l_organization_id,l_asset_group,l_instance_number,l_serial_number
1000: from wip_discrete_jobs wdj,
1001: csi_item_instances cii,
1002: mtl_system_items_b_kfv msi,
1003: wip_entities we
1004: where wdj.wip_entity_id=p_wip_entity_id(i)

Line 1013: wip_discrete_jobs wdj

1009:
1010: begin
1011: select msi.concatenated_segments into l_asset_activity
1012: from mtl_system_items_b_kfv msi,
1013: wip_discrete_jobs wdj
1014: where wdj.primary_item_id=msi.inventory_item_id and
1015: wdj.organization_id=msi.organization_id and
1016: wdj.wip_entity_id=p_wip_entity_id(i) ;
1017: exception

Line 1118: wip_discrete_jobs wdj,

1114: eafc.comments as "COMMENTS")) into l_xmlTypeFailureData
1115: from eam_asset_failures eaf,
1116: eam_asset_failure_codes eafc,
1117: eam_work_order_details ewod,
1118: wip_discrete_jobs wdj,
1119: eam_failure_set_associations easa,
1120: eam_failure_sets efs
1121: where wdj.wip_entity_id =eaf.source_id and
1122: eaf.source_type=1 and

Line 1150: from csi_item_instances csi, wip_discrete_jobs wdj

1146:
1147: --Adding Warranty Expiration Date
1148: begin
1149: select XMLConcat(XMLELEMENT("WARRANTYEXPDATE",fnd_date.date_to_displayDT(dateval => Convert_to_client_time(csi.SUPPLIER_WARRANTY_EXP_DATE), calendar_aware => FND_DATE.calendar_aware_alt)),l_xmlTemp3) into l_xmlTemp3
1150: from csi_item_instances csi, wip_discrete_jobs wdj
1151: where wdj.maintenance_object_id=csi.instance_id
1152: and wdj.maintenance_object_type=3
1153: and wdj.wip_entity_id=p_wip_entity_id(i);
1154: exception

Line 1169: FROM EAM_JOB_COMPLETION_TXNS EJT,WIP_DISCRETE_JOBS WDJ

1165: WHERE TRANSACTION_TYPE=1
1166: AND TRANSACTION_ID=
1167: (
1168: SELECT MAX(TRANSACTION_ID)
1169: FROM EAM_JOB_COMPLETION_TXNS EJT,WIP_DISCRETE_JOBS WDJ
1170: WHERE EJT.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
1171: AND EJT.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
1172: AND WDJ.WIP_ENTITY_ID=p_wip_entity_id(i)
1173: );

Line 1183: from mtl_system_items_kfv msi, wip_discrete_jobs wdj

1179:
1180: --Adding Asset Group Description
1181: begin
1182: select XMLConcat(XMLELEMENT("ASSETGRPDESC",msi.description),l_xmlTemp3) into l_xmlTemp3
1183: from mtl_system_items_kfv msi, wip_discrete_jobs wdj
1184: where nvl(wdj.asset_group_id,wdj.rebuild_item_id)=msi.inventory_item_id
1185: and wdj.organization_id=msi.organization_id
1186: and wdj.wip_entity_id=p_wip_entity_id(i);
1187: exception

Line 1195: from eam_org_maint_defaults eomd, mtl_eam_locations mel, wip_discrete_jobs wdj

1191:
1192: --Adding Area Info
1193: begin
1194: select XMLConcat(XMLFOREST(mel.location_codes as "AREA" ,mel.description as "AREADESC"),l_xmlTemp3) into l_xmlTemp3
1195: from eam_org_maint_defaults eomd, mtl_eam_locations mel, wip_discrete_jobs wdj
1196: where eomd.object_id = wdj.maintenance_object_id
1197: and eomd.object_type = 50
1198: and eomd.organization_id =wdj.organization_id
1199: and wdj.wip_entity_id=p_wip_entity_id(i)