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_PLANNING_PARAMETERS

Line 572: CSP_PLANNING_PARAMETERS cpp

568: ,cutt.TRANSACTION_TYPE_ID
569: ,mtt.TRANSACTION_ACTION_ID
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

Line 596: (select 'x' from CSP_PLANNING_PARAMETERS cpp

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
597: where cpp.organization_id = csi2.organization_id
598: and cpp.SECONDARY_INVENTORY = csi2.secondary_inventory_name
599: and cpp.forecast_rule_id is not null) /* Do not include subinventories that
600: have forecast rules defined */

Line 939: CSP_PLANNING_PARAMETERS cpp,

935: ,cutt.TRANSACTION_TYPE_ID
936: ,mtt.TRANSACTION_ACTION_ID
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

Line 962: (select 'x' from CSP_PLANNING_PARAMETERS cpp

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
963: where cpp.organization_id = csi2.organization_id
964: and cpp.SECONDARY_INVENTORY = csi2.secondary_inventory_name
965: and cpp.forecast_rule_id is not null) /* Do not include subinventories that
966: have forecast rules defined */