VIEW: APPS.OKL_INS_PRODUCTS_UV

Source

View Text - Preformatted

SELECT FND.MEANING MEANING, FND.LOOKUP_CODE LOOKUP_CODE, IPTB.ID ID, IPTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, IPTT.SFWT_FLAG SFWT_FLAG, IPTB.ISU_ID ISU_ID , IPTB.IPD_ID IPD_ID, IPTB.POLICY_SYMBOL POLICY_SYMBOL , IPTB.IPT_TYPE IPT_TYPE , IPTT.NAME NAME , IPTB.FACTOR_MAX FACTOR_MAX, IPTB.DATE_FROM DATE_FROM, IPTB.FACTOR_MIN FACTOR_MIN, IPTB.DATE_TO DATE_TO , FIFC.MEANING FACTOR_NAME , IPTB.FACTOR_CODE FACTOR_CODE , IPTB.COVERAGE_MIN COVERAGE_MIN, IPTB.COVERAGE_MAX COVERAGE_MAX, IPTB.DEAL_MONTHS_MIN DEAL_MONTHS_MIN , IPTB.DEAL_MONTHS_MAX DEAL_MONTHS_MAX , IPTB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , IPTB.ATTRIBUTE1 ATTRIBUTE1 , IPTB.ATTRIBUTE2 ATTRIBUTE2, IPTB.ATTRIBUTE3 ATTRIBUTE3 , IPTB.ATTRIBUTE4 ATTRIBUTE4, IPTB.ATTRIBUTE5 ATTRIBUTE5 , IPTB.ATTRIBUTE6 ATTRIBUTE6, IPTB.ATTRIBUTE7 ATTRIBUTE7 , IPTB.ATTRIBUTE8 ATTRIBUTE8, IPTB.ATTRIBUTE9 ATTRIBUTE9 , IPTB.ATTRIBUTE10 ATTRIBUTE10, IPTB.ATTRIBUTE11 ATTRIBUTE11 , IPTB.ATTRIBUTE12 ATTRIBUTE12, IPTB.ATTRIBUTE13 ATTRIBUTE13 , IPTB.ATTRIBUTE14 ATTRIBUTE14, IPTB.ATTRIBUTE15 ATTRIBUTE15 , IPTB.CREATED_BY CREATED_BY , IPTB.CREATION_DATE CREATION_DATE, IPTB.LAST_UPDATED_BY LAST_UPDATED_BY, IPTB.LAST_UPDATE_DATE LAST_UPDATE_DATE , IPTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , OI.PARTY_NAME PARTY_NAME, OI.PARTY_ID PARTY_ID, OSI.ITEM_TYPE ITEM_TYPE, OSI.ID1 ID1, OSI.ID2 Inventory_org_id, OSI.NAME MTLNAME , DECODE(NVL(IPTB.DATE_TO,NULL),NULL,'ACTIVE',DECODE(SIGN(MONTHS_BETWEEN(IPTB.DATE_TO,SYSDATE)),1,'ACTIVE','INACTIVE')) STATUS , IPTB.FACTOR_AMOUNT_YN, OSI.ORGANIZATION_ID ORG_ID FROM FND_LOOKUPS FIFC,OKL_INS_PRODUCTS_TL IPTT,OKL_INS_PRODUCTS_B IPTB,FND_LOOKUPS FND,OKX_INS_PROVIDER_V OI,OKX_SYSTEM_ITEMS_V OSI WHERE IPTB.ID = IPTT.ID AND IPTT.LANGUAGE = USERENV('LANG') AND IPTB.IPT_TYPE = FND.LOOKUP_CODE AND FND.LOOKUP_TYPE = 'OKL_INSURANCE_PRODUCT_TYPE' AND IPTB.ISU_ID = OI.PARTY_ID AND IPTB.IPD_ID = OSI.ID1 AND IPTB.FACTOR_CODE = FIFC.LOOKUP_CODE AND FIFC.LOOKUP_TYPE = 'OKL_INSURANCE_FACTOR'

View Text - HTML Formatted

SELECT FND.MEANING MEANING
, FND.LOOKUP_CODE LOOKUP_CODE
, IPTB.ID ID
, IPTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IPTT.SFWT_FLAG SFWT_FLAG
, IPTB.ISU_ID ISU_ID
, IPTB.IPD_ID IPD_ID
, IPTB.POLICY_SYMBOL POLICY_SYMBOL
, IPTB.IPT_TYPE IPT_TYPE
, IPTT.NAME NAME
, IPTB.FACTOR_MAX FACTOR_MAX
, IPTB.DATE_FROM DATE_FROM
, IPTB.FACTOR_MIN FACTOR_MIN
, IPTB.DATE_TO DATE_TO
, FIFC.MEANING FACTOR_NAME
, IPTB.FACTOR_CODE FACTOR_CODE
, IPTB.COVERAGE_MIN COVERAGE_MIN
, IPTB.COVERAGE_MAX COVERAGE_MAX
, IPTB.DEAL_MONTHS_MIN DEAL_MONTHS_MIN
, IPTB.DEAL_MONTHS_MAX DEAL_MONTHS_MAX
, IPTB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IPTB.ATTRIBUTE1 ATTRIBUTE1
, IPTB.ATTRIBUTE2 ATTRIBUTE2
, IPTB.ATTRIBUTE3 ATTRIBUTE3
, IPTB.ATTRIBUTE4 ATTRIBUTE4
, IPTB.ATTRIBUTE5 ATTRIBUTE5
, IPTB.ATTRIBUTE6 ATTRIBUTE6
, IPTB.ATTRIBUTE7 ATTRIBUTE7
, IPTB.ATTRIBUTE8 ATTRIBUTE8
, IPTB.ATTRIBUTE9 ATTRIBUTE9
, IPTB.ATTRIBUTE10 ATTRIBUTE10
, IPTB.ATTRIBUTE11 ATTRIBUTE11
, IPTB.ATTRIBUTE12 ATTRIBUTE12
, IPTB.ATTRIBUTE13 ATTRIBUTE13
, IPTB.ATTRIBUTE14 ATTRIBUTE14
, IPTB.ATTRIBUTE15 ATTRIBUTE15
, IPTB.CREATED_BY CREATED_BY
, IPTB.CREATION_DATE CREATION_DATE
, IPTB.LAST_UPDATED_BY LAST_UPDATED_BY
, IPTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IPTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OI.PARTY_NAME PARTY_NAME
, OI.PARTY_ID PARTY_ID
, OSI.ITEM_TYPE ITEM_TYPE
, OSI.ID1 ID1
, OSI.ID2 INVENTORY_ORG_ID
, OSI.NAME MTLNAME
, DECODE(NVL(IPTB.DATE_TO
, NULL)
, NULL
, 'ACTIVE'
, DECODE(SIGN(MONTHS_BETWEEN(IPTB.DATE_TO
, SYSDATE))
, 1
, 'ACTIVE'
, 'INACTIVE')) STATUS
, IPTB.FACTOR_AMOUNT_YN
, OSI.ORGANIZATION_ID ORG_ID
FROM FND_LOOKUPS FIFC
, OKL_INS_PRODUCTS_TL IPTT
, OKL_INS_PRODUCTS_B IPTB
, FND_LOOKUPS FND
, OKX_INS_PROVIDER_V OI
, OKX_SYSTEM_ITEMS_V OSI
WHERE IPTB.ID = IPTT.ID
AND IPTT.LANGUAGE = USERENV('LANG')
AND IPTB.IPT_TYPE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKL_INSURANCE_PRODUCT_TYPE'
AND IPTB.ISU_ID = OI.PARTY_ID
AND IPTB.IPD_ID = OSI.ID1
AND IPTB.FACTOR_CODE = FIFC.LOOKUP_CODE
AND FIFC.LOOKUP_TYPE = 'OKL_INSURANCE_FACTOR'