Product: | OZF - Trade Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OZF_CLAIM_LINES_V |
SELECT OCL.CLAIM_LINE_ID
, OCL.OBJECT_VERSION_NUMBER
, OCL.LAST_UPDATE_DATE
, OCL.LAST_UPDATED_BY
, OCL.CREATION_DATE
, OCL.CREATED_BY
, OCL.LAST_UPDATE_LOGIN
, OCL.REQUEST_ID
, OCL.PROGRAM_APPLICATION_ID
, OCL.PROGRAM_UPDATE_DATE
, OCL.PROGRAM_ID
, OCL.CREATED_FROM
, OCL.CLAIM_ID
, OCL.LINE_NUMBER
, OCL.SPLIT_FROM_CLAIM_LINE_ID
, OCL.AMOUNT
, OCL.CLAIM_CURRENCY_AMOUNT
, OCL.ACCTD_AMOUNT
, OCL.CURRENCY_CODE
, OCL.EXCHANGE_RATE_TYPE
, OCL.EXCHANGE_RATE_DATE
, OCL.EXCHANGE_RATE
, OCL.TAX_CODE
, OCL.SET_OF_BOOKS_ID
, OCL.VALID_FLAG
, OCL.SOURCE_OBJECT_ID
, OCL.SOURCE_OBJECT_CLASS
, OCL.SOURCE_OBJECT_TYPE_ID
, OCL.PLAN_ID
, OCL.OFFER_ID
, OCL.UTILIZATION_ID
, OCL.PAYMENT_METHOD
, LK_PM.MEANING
, OCL.PAYMENT_REFERENCE_ID
, OCL.PAYMENT_REFERENCE_NUMBER
, OCL.PAYMENT_REFERENCE_DATE
, OCL.VOUCHER_ID
, OCL.VOUCHER_NUMBER
, OCL.PAYMENT_STATUS
, OCL.APPROVED_FLAG
, OCL.APPROVED_DATE
, OCL.APPROVED_BY
, JRE1.SOURCE_NAME
, OCL.SETTLED_DATE
, OCL.SETTLED_BY
, JRE2.SOURCE_NAME
, OCL.PERFORMANCE_COMPLETE_FLAG
, OCL.PERFORMANCE_ATTACHED_FLAG
, OCL.ATTRIBUTE_CATEGORY
, OCL.ATTRIBUTE1
, OCL.ATTRIBUTE2
, OCL.ATTRIBUTE3
, OCL.ATTRIBUTE4
, OCL.ATTRIBUTE5
, OCL.ATTRIBUTE6
, OCL.ATTRIBUTE7
, OCL.ATTRIBUTE8
, OCL.ATTRIBUTE9
, OCL.ATTRIBUTE10
, OCL.ATTRIBUTE11
, OCL.ATTRIBUTE12
, OCL.ATTRIBUTE13
, OCL.ATTRIBUTE14
, OCL.ATTRIBUTE15
, OCL.ORG_ID FROM OZF_CLAIM_LINES OCL
, OZF_SYS_PARAMETERS OSP
, AMS_LOOKUPS LK_PM
, JTF_RS_RESOURCE_EXTNS JRE1
, JTF_RS_RESOURCE_EXTNS JRE2
WHERE OCL.SET_OF_BOOKS_ID = OSP.SET_OF_BOOKS_ID
AND LK_PM.LOOKUP_TYPE (+) = 'AMS_PAYMENT_METHOD'
AND OCL.PAYMENT_METHOD = LK_PM.LOOKUP_CODE (+)
AND OCL.APPROVED_BY = JRE1.RESOURCE_ID (+)
AND OCL.SETTLED_BY = JRE2.RESOURCE_ID (+)