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.CS_SERVICEREQUEST_PUB dependencies on CSI_ITEM_INSTANCES

Line 6543: from csi_item_instances csi

6539: ,(SELECT cat.concatenated_segments
6540: FROM mtl_categories_b_kfv cat
6541: WHERE cat.category_id = inc.category_id )ItemCategory
6542: ,( select csi.instance_number
6543: from csi_item_instances csi
6544: where csi.instance_id = inc.customer_product_id ) InstanceNumber
6545: , nvl((select csi.serial_number
6546: from csi_item_instances csi
6547: where csi.instance_id = inc.customer_product_id ), inc.current_serial_number ) SerialNumber

Line 6546: from csi_item_instances csi

6542: ,( select csi.instance_number
6543: from csi_item_instances csi
6544: where csi.instance_id = inc.customer_product_id ) InstanceNumber
6545: , nvl((select csi.serial_number
6546: from csi_item_instances csi
6547: where csi.instance_id = inc.customer_product_id ), inc.current_serial_number ) SerialNumber
6548: ,nvl( (select csi.external_reference
6549: from csi_item_instances csi
6550: where csi.instance_id = inc.customer_product_id ), inc.external_reference ) TagNumber

Line 6549: from csi_item_instances csi

6545: , nvl((select csi.serial_number
6546: from csi_item_instances csi
6547: where csi.instance_id = inc.customer_product_id ), inc.current_serial_number ) SerialNumber
6548: ,nvl( (select csi.external_reference
6549: from csi_item_instances csi
6550: where csi.instance_id = inc.customer_product_id ), inc.external_reference ) TagNumber
6551: ,( SELECT sys.name
6552: FROM CSI_SYSTEMS_TL sys
6553: WHERE sys.system_id = inc.system_id

Line 6558: csi_item_instances instance

6554: and sys.LANGUAGE = USERENV('LANG') ) SystemNumber
6555: ,(CASE WHEN inc.cp_component_id is not null THEN
6556: (select product_a.concatenated_segments
6557: from mtl_system_items_b_kfv product_a,
6558: csi_item_instances instance
6559: where product_a.inventory_item_id = instance.inventory_item_id
6560: and product_a.organization_id = inc.inv_organization_id
6561: and inc.cp_component_id=instance.instance_id )
6562: ELSE

Line 6571: csi_item_instances instance

6567: END ) Component
6568: ,(CASE WHEN inc.cp_subcomponent_id is not null THEN
6569: (select product_b.concatenated_segments
6570: from mtl_system_items_b_kfv product_b,
6571: csi_item_instances instance
6572: where product_b.inventory_item_id = instance.inventory_item_id
6573: and product_b.organization_id = inc.inv_organization_id
6574: and inc.cp_subcomponent_id = instance.instance_id )
6575: ELSE

Line 6585: csi_item_instances instance

6581: , nvl2(inc.customer_product_id, instance.inventory_revision,
6582: inc.inv_item_revision ) ItemRevision
6583: , nvl2(inc.customer_product_id, (select instance.inventory_revision
6584: from mtl_system_items_b_kfv product_a,
6585: csi_item_instances instance
6586: where product_a.inventory_item_id = instance.inventory_item_id
6587: and product_a.organization_id = inc.inv_organization_id
6588: and inc.cp_component_id=instance.instance_id)
6589: , inc.inv_component_version ) ComponentRevision

Line 6592: csi_item_instances instance

6588: and inc.cp_component_id=instance.instance_id)
6589: , inc.inv_component_version ) ComponentRevision
6590: , nvl2(inc.customer_product_id, (select instance.inventory_revision
6591: from mtl_system_items_b_kfv product_b,
6592: csi_item_instances instance
6593: where product_b.inventory_item_id = instance.inventory_item_id
6594: and product_b.organization_id = inc.inv_organization_id
6595: and inc.cp_subcomponent_id = instance.instance_id )
6596: , inc.inv_subcomponent_version ) SubComponentRevision

Line 6676: ,csi_item_instances instance

6672: ,cs_incidents_all_tl tl
6673: ,hz_parties party
6674: ,cs_hz_sr_contact_points sr_cont
6675: ,hz_contact_points hzcp
6676: ,csi_item_instances instance
6677: where
6678: inc.incident_id = tl.incident_id
6679: and tl.language = userenv('lang')
6680: and inc.customer_id = party.party_id (+)