[Home] [Help]
386: CSI_COUNTERS_TL CTL2,
387: CSI_COUNTERS_B CBS,
388: CSI_COUNTER_READINGS CCR1,
389: CSI_COUNTER_READINGS CCR2,
390: csi_item_instances cii,
391: wip_discrete_jobs wdj,
392: (
393: SELECT
394: *
498: lu.meaning as "SUPPLYTYPE")) AssetBom
499: from bom_inventory_components bic,
500: mtl_system_items_kfv msik,
501: wip_discrete_jobs wdj,
502: csi_item_instances cii,
503: bom_bill_of_materials bbom,
504: mfg_lookups lu
505: where bic.effectivity_date <= sysdate
506: and (bic.disable_date >= sysdate or
565: from
566: mtl_eam_network_assets_v mena
567: , mtl_eam_asset_numbers_v msn1
568: , mtl_eam_asset_numbers_v msn2
569: ,csi_item_instances cii
570: where
571: mena.organization_id=msn1.current_organization_id
572: and mena.network_item_id=msn1.inventory_item_id
573: and mena.network_serial_number=msn1.serial_number
601: FROM eam_work_orders_v
602: WHERE wip_entity_id=p_wip_entity_id(i);
603:
604: SELECT NETWORK_ASSET_FLAG into l_asset_route_flag
605: FROM csi_item_instances
606: WHERE INSTANCE_NUMBER = l_instance_number
607: AND INVENTORY_ITEM_ID = l_inventory_id
608: AND SERIAL_NUMBER = l_serial_number;
609:
778: wdj.organization_id,
779: msi.concatenated_segments,
780: cii.instance_number,cii.serial_number into l_wip_entity_name,l_organization_id,l_asset_group,l_instance_number,l_serial_number
781: from wip_discrete_jobs wdj,
782: csi_item_instances cii,
783: mtl_system_items_b_kfv msi,
784: wip_entities we
785: where wdj.wip_entity_id=p_wip_entity_id(i)
786: and wdj.wip_entity_id=we.wip_entity_id
894:
895: --Adding Warranty Expiration Date
896: begin
897: select XMLConcat(XMLELEMENT("WARRANTYEXPDATE",fnd_date.date_to_displayDT(Convert_to_client_time(csi.SUPPLIER_WARRANTY_EXP_DATE))),l_xmlTemp3) into l_xmlTemp3
898: from csi_item_instances csi, wip_discrete_jobs wdj
899: where wdj.maintenance_object_id=csi.instance_id
900: and wdj.maintenance_object_type=3
901: and wdj.wip_entity_id=p_wip_entity_id(i);
902: exception