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.

[Home] [Help]

APPS.EDW_ITEMS_M_SIZE dependencies on AS_INTEREST_TYPES_V

Line 433: AS_INTEREST_TYPES_V INTYP ,

429: avg(nvl(vsize(TO_DATE(NULL)), 0)) +
430: 16
431: FROM
432: AS_INTEREST_CODES_V CD ,
433: AS_INTEREST_TYPES_V INTYP ,
434: EDW_LOCAL_INSTANCE INST
435: WHERE
436: CD.INTEREST_TYPE_ID = INTYP.INTEREST_TYPE_ID
437: AND CD.PARENT_INTEREST_CODE_ID IS NULL

Line 469: AS_INTEREST_TYPES_V INTYP ,

465: 16
466: FROM
467: AS_INTEREST_CODES_V SCD ,
468: AS_INTEREST_CODES_V PCD ,
469: AS_INTEREST_TYPES_V INTYP ,
470: EDW_LOCAL_INSTANCE INST
471: WHERE
472: SCD.PARENT_INTEREST_CODE_ID = PCD.INTEREST_CODE_ID
473: AND PCD.PARENT_INTEREST_CODE_ID IS NULL

Line 506: AS_INTEREST_TYPES_V INTYP ,

502: avg(nvl(vsize(NULL), 0)) +
503: avg(nvl(vsize(TO_DATE(NULL)), 0)) +
504: 16
505: FROM
506: AS_INTEREST_TYPES_V INTYP ,
507: EDW_LOCAL_INSTANCE INST
508: WHERE
509: INTYP.EXPECTED_PURCHASE_FLAG = 'Y'
510: and intyp.last_update_date between