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.ISC_FS_INV_USG_ETL_PKG dependencies on CSP_SEC_INVENTORIES

Line 574: ,CSP_SEC_INVENTORIES csi1

570: ,mtt.TRANSACTION_SOURCE_TYPE_ID
571: FROM
572: CSP_PLANNING_PARAMETERS cpp
573: ,CSP_USG_TRANSACTION_TYPES cutt
574: ,CSP_SEC_INVENTORIES csi1
575: ,MTL_TRANSACTION_TYPES mtt
576: WHERE
577: cpp.FORECAST_RULE_ID = cutt.FORECAST_RULE_ID
578: and csi1.organization_id = cpp.organization_id

Line 592: CSP_SEC_INVENTORIES csi2

588: ,93 transaction_type_id /* Field Service Usage transaction type */
589: ,1 TRANSACTION_ACTION_ID
590: ,13 TRANSACTION_SOURCE_TYPE_ID
591: FROM
592: CSP_SEC_INVENTORIES csi2
593: WHERE
594: csi2.CONDITION_TYPE = 'G' /* Usable Subinventory */
595: and not exists
596: (select 'x' from CSP_PLANNING_PARAMETERS cpp

Line 941: CSP_SEC_INVENTORIES csi1,

937: ,mtt.TRANSACTION_SOURCE_TYPE_ID
938: FROM
939: CSP_PLANNING_PARAMETERS cpp,
940: CSP_USG_TRANSACTION_TYPES cutt,
941: CSP_SEC_INVENTORIES csi1,
942: MTL_TRANSACTION_TYPES mtt
943: WHERE
944: cpp.FORECAST_RULE_ID = cutt.FORECAST_RULE_ID
945: AND csi1.organization_id = cpp.organization_id

Line 958: FROM CSP_SEC_INVENTORIES csi2

954: ,csi2.SECONDARY_INVENTORY_NAME
955: ,93 transaction_type_id /* Field Service Usage transaction type */
956: ,1 TRANSACTION_ACTION_ID
957: ,13 TRANSACTION_SOURCE_TYPE_ID
958: FROM CSP_SEC_INVENTORIES csi2
959: WHERE
960: csi2.CONDITION_TYPE = 'G' /* Usable Subinventory */
961: and not exists
962: (select 'x' from CSP_PLANNING_PARAMETERS cpp