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 MTL_SYSTEM_ITEMS_B_KFV

Line 6450: from mtl_system_items_b_kfv product_b

6446: from hz_cust_accounts account
6447: where account.cust_account_id = inc.account_id) accountnumber
6448: ,inc.inventory_item_id InventoryItemId
6449: ,(select product_b.concatenated_segments
6450: from mtl_system_items_b_kfv product_b
6451: where product_b.inventory_item_id = inc.inventory_item_id
6452: and product_b.organization_id = inc.inv_organization_id) Product
6453: ,(select product_tl.description
6454: from mtl_system_items_tl product_tl

Line 6557: from mtl_system_items_b_kfv product_a,

6553: WHERE sys.system_id = inc.system_id
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 )

Line 6564: from mtl_system_items_b_kfv product_a

6560: and product_a.organization_id = inc.inv_organization_id
6561: and inc.cp_component_id=instance.instance_id )
6562: ELSE
6563: (select product_a.concatenated_segments
6564: from mtl_system_items_b_kfv product_a
6565: where product_a.inventory_item_id = inc.inv_component_id
6566: and product_a.organization_id = inc.inv_organization_id )
6567: END ) Component
6568: ,(CASE WHEN inc.cp_subcomponent_id is not null THEN

Line 6570: from mtl_system_items_b_kfv product_b,

6566: and product_a.organization_id = inc.inv_organization_id )
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 )

Line 6577: from mtl_system_items_b_kfv product_b

6573: and product_b.organization_id = inc.inv_organization_id
6574: and inc.cp_subcomponent_id = instance.instance_id )
6575: ELSE
6576: (select product_b.concatenated_segments
6577: from mtl_system_items_b_kfv product_b
6578: where product_b.inventory_item_id = inc.inv_subcomponent_id
6579: and product_b.organization_id = inc.inv_organization_id )
6580: END ) SubComponent
6581: , nvl2(inc.customer_product_id, instance.inventory_revision,

Line 6584: from mtl_system_items_b_kfv product_a,

6580: END ) SubComponent
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)

Line 6591: from mtl_system_items_b_kfv product_b,

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
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 )