VIEW: APPS.OZF_CLAIM_LINES_V

Source

View Text - Preformatted

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_AMOUNT ,OCL.CLAIM_CURR_TAX_AMOUNT ,OCL.ACCTD_TAX_AMOUNT ,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.SOURCE_OBJECT_LINE_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.SELECT_CUST_CHILDREN_FLAG ,OCL.BUY_GROUP_CUST_ACCOUNT_ID ,OCL.BUY_GROUP_PARTY_ID ,OCL.CREDIT_TO ,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 ,OCL.ACTIVITY_LINE_ID ,OCL.SALE_DATE ,OCL.ITEM_TYPE ,OCL.OFFER_TYPE ,OCL.EARNINGS_END_DATE ,OCL.PRORATE_EARNINGS_FLAG FROM OZF_CLAIM_LINES OCL , OZF_SYS_PARAMETERS OSP , OZF_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 (+) = 'OZF_PAYMENT_METHOD' AND OCL.PAYMENT_METHOD = LK_PM.LOOKUP_CODE (+) AND OCL.APPROVED_BY = JRE1.RESOURCE_ID (+) AND OCL.SETTLED_BY = JRE2.RESOURCE_ID (+)

View Text - HTML Formatted

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_AMOUNT
, OCL.CLAIM_CURR_TAX_AMOUNT
, OCL.ACCTD_TAX_AMOUNT
, 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.SOURCE_OBJECT_LINE_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.SELECT_CUST_CHILDREN_FLAG
, OCL.BUY_GROUP_CUST_ACCOUNT_ID
, OCL.BUY_GROUP_PARTY_ID
, OCL.CREDIT_TO
, 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
, OCL.ACTIVITY_LINE_ID
, OCL.SALE_DATE
, OCL.ITEM_TYPE
, OCL.OFFER_TYPE
, OCL.EARNINGS_END_DATE
, OCL.PRORATE_EARNINGS_FLAG
FROM OZF_CLAIM_LINES OCL
, OZF_SYS_PARAMETERS OSP
, OZF_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 (+) = 'OZF_PAYMENT_METHOD'
AND OCL.PAYMENT_METHOD = LK_PM.LOOKUP_CODE (+)
AND OCL.APPROVED_BY = JRE1.RESOURCE_ID (+)
AND OCL.SETTLED_BY = JRE2.RESOURCE_ID (+)