APPS.EAM_WORKORDERREP_PVT dependencies on CSI_ITEM_INSTANCES

Line 408: csi_item_instances cii,

404: CSI_COUNTERS_TL CTL2,
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: *

Line 520: csi_item_instances cii,

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
524: and (bic.disable_date >= sysdate or

Line 587: ,csi_item_instances cii

583: from
584: mtl_eam_network_assets_v mena
585: , mtl_eam_asset_numbers_v msn1
586: , mtl_eam_asset_numbers_v msn2
587: ,csi_item_instances cii
588: where
589: mena.organization_id=msn1.current_organization_id
590: and mena.network_item_id=msn1.inventory_item_id
591: and mena.network_serial_number=msn1.serial_number

Line 795: FROM csi_item_instances

791:
792: --Exception block added for bug 7758322
793: BEGIN
794: SELECT NETWORK_ASSET_FLAG into l_asset_route_flag
795: FROM csi_item_instances
796: WHERE INSTANCE_NUMBER = l_instance_number
797: AND INVENTORY_ITEM_ID = l_inventory_id
798: AND SERIAL_NUMBER = l_serial_number;
799:

Line 1001: csi_item_instances cii,

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)
1005: and wdj.wip_entity_id=we.wip_entity_id

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