VIEW: APPS.OZF_CLAIMS_WEBADI_DOWNLOAD_V

Source

View Text - Preformatted

SELECT HDR.INTERFACE_CLAIM_ID, HDR.LAST_UPDATE_DATE, HDR.LAST_UPDATED_BY, HDR.LAST_UPDATE_LOGIN, HDR.CLAIM_NUMBER, HDR.CLAIM_TYPE_ID, HDR.CLAIM_DATE, HDR.DUE_DATE, HDR.SPLIT_FROM_CLAIM_ID, HDR.AMOUNT, HDR.ACCTD_AMOUNT, HDR.CURRENCY_CODE, HDR.EXCHANGE_RATE_TYPE, HDR.EXCHANGE_RATE_DATE, HDR.EXCHANGE_RATE, HDR.SET_OF_BOOKS_ID, HDR.ORIGINAL_CLAIM_DATE, HDR.SOURCE_OBJECT_ID, HDR.SOURCE_OBJECT_CLASS, HDR.SOURCE_OBJECT_TYPE_ID, HDR.SOURCE_OBJECT_NUMBER, HDR.CUST_ACCOUNT_ID, HDR.CUST_BILLTO_ACCT_SITE_ID, HDR.LOCATION_ID, HDR.REASON_TYPE, HDR.REASON_CODE_ID, HDR.STATUS_CODE, HDR.SALES_REP_ID, HDR.COLLECTOR_ID, HDR.CONTACT_ID, HDR.BROKER_ID, HDR.TERRITORY_ID, HDR.CUSTOMER_REF_DATE, HDR.CUSTOMER_REF_NUMBER, HDR.ASSIGNED_TO, HDR.RECEIPT_ID, HDR.RECEIPT_NUMBER, HDR.DOC_SEQUENCE_ID, HDR.DOC_SEQUENCE_VALUE, HDR.PAYMENT_METHOD, HDR.VOUCHER_ID, HDR.VOUCHER_NUMBER, HDR.PAYMENT_REFERENCE_ID, HDR.PAYMENT_REFERENCE_NUMBER, HDR.PAYMENT_REFERENCE_DATE, HDR.PAYMENT_STATUS, HDR.APPROVED_FLAG, HDR.APPROVED_DATE, HDR.APPROVED_BY, HDR.SETTLED_DATE, HDR.SETTLED_BY, HDR.ATTRIBUTE_CATEGORY, HDR.ATTRIBUTE1, HDR.ATTRIBUTE2, HDR.ATTRIBUTE3, HDR.ATTRIBUTE4, HDR.ATTRIBUTE5, HDR.AMOUNT_ADJUSTED, HDR.AMOUNT_REMAINING, HDR.AMOUNT_SETTLED, HDR.USER_STATUS_ID, HDR.CLAIM_CLASS, HDR.OWNER_ID, HDR.HISTORY_EVENT, HDR.HISTORY_EVENT_DATE, HDR.HISTORY_EVENT_DESCRIPTION, HDR.DUPLICATE_CLAIM_ID, HDR.SPLIT_DATE, HDR.ROOT_CLAIM_ID, HDR.CLAIM_ID, HDR.ACCTD_AMOUNT_REMAINING, HDR.TAX_AMOUNT, HDR.TAX_CODE, HDR.TAX_CALCULATION_FLAG, HDR.CUST_SHIPTO_ACCT_SITE_ID, HDR.PAY_RELATED_ACCOUNT_FLAG, HDR.RELATED_CUST_ACCOUNT_ID, HDR.RELATED_SITE_USE_ID, HDR.RELATIONSHIP_TYPE, HDR.VENDOR_ID, HDR.VENDOR_SITE_ID, HDR.TASK_TEMPLATE_GROUP_ID, HDR.GL_DATE, HDR.EFFECTIVE_DATE, HDR.CUSTOM_SETUP_ID, HDR.TASK_ID, HDR.COUNTRY_ID, HDR.COMMENTS, HDR.ACCTD_AMOUNT_ADJUSTED, HDR.ACCTD_AMOUNT_SETTLED, HDR.ORDER_TYPE_ID, LIN.INTERFACE_CLAIM_LINE_ID , LIN.LINE_NUMBER , LIN.SPLIT_FROM_CLAIM_LINE_ID , LIN.AMOUNT , LIN.ACCTD_AMOUNT , LIN.CURRENCY_CODE , LIN.EXCHANGE_RATE_TYPE , LIN.EXCHANGE_RATE_DATE , LIN.EXCHANGE_RATE , LIN.SET_OF_BOOKS_ID , LIN.VALID_FLAG , LIN.SOURCE_OBJECT_ID , LIN.SOURCE_OBJECT_CLASS , LIN.SOURCE_OBJECT_TYPE_ID , LIN.PLAN_ID , LIN.OFFER_ID , LIN.PAYMENT_METHOD , LIN.PAYMENT_REFERENCE_ID , LIN.PAYMENT_REFERENCE_NUMBER , LIN.PAYMENT_REFERENCE_DATE , LIN.VOUCHER_ID , LIN.VOUCHER_NUMBER , LIN.PAYMENT_STATUS , LIN.APPROVED_FLAG , LIN.APPROVED_DATE , LIN.APPROVED_BY , LIN.SETTLED_DATE , LIN.SETTLED_BY , LIN.PERFORMANCE_COMPLETE_FLAG , LIN.PERFORMANCE_ATTACHED_FLAG , LIN.UTILIZATION_ID , LIN.CLAIM_CURRENCY_AMOUNT , LIN.TAX_CODE , LIN.ITEM_ID , LIN.ITEM_DESCRIPTION , LIN.QUANTITY , LIN.QUANTITY_UOM , LIN.RATE , LIN.ACTIVITY_TYPE , LIN.ACTIVITY_ID , LIN.EARNINGS_ASSOCIATED_FLAG , LIN.RELATED_CUST_ACCOUNT_ID , LIN.RELATIONSHIP_TYPE , LIN.COMMENTS , LIN.SOURCE_OBJECT_LINE_ID , LIN.SELECT_CUST_CHILDREN_FLAG , LIN.BUY_GROUP_CUST_ACCOUNT_ID , LIN.CREDIT_TO FROM OZF_CLAIMS_INT_ALL HDR, OZF_CLAIM_LINES_INT_ALL LIN WHERE HDR.INTERFACE_CLAIM_ID = LIN.INTERFACE_CLAIM_ID

View Text - HTML Formatted

SELECT HDR.INTERFACE_CLAIM_ID
, HDR.LAST_UPDATE_DATE
, HDR.LAST_UPDATED_BY
, HDR.LAST_UPDATE_LOGIN
, HDR.CLAIM_NUMBER
, HDR.CLAIM_TYPE_ID
, HDR.CLAIM_DATE
, HDR.DUE_DATE
, HDR.SPLIT_FROM_CLAIM_ID
, HDR.AMOUNT
, HDR.ACCTD_AMOUNT
, HDR.CURRENCY_CODE
, HDR.EXCHANGE_RATE_TYPE
, HDR.EXCHANGE_RATE_DATE
, HDR.EXCHANGE_RATE
, HDR.SET_OF_BOOKS_ID
, HDR.ORIGINAL_CLAIM_DATE
, HDR.SOURCE_OBJECT_ID
, HDR.SOURCE_OBJECT_CLASS
, HDR.SOURCE_OBJECT_TYPE_ID
, HDR.SOURCE_OBJECT_NUMBER
, HDR.CUST_ACCOUNT_ID
, HDR.CUST_BILLTO_ACCT_SITE_ID
, HDR.LOCATION_ID
, HDR.REASON_TYPE
, HDR.REASON_CODE_ID
, HDR.STATUS_CODE
, HDR.SALES_REP_ID
, HDR.COLLECTOR_ID
, HDR.CONTACT_ID
, HDR.BROKER_ID
, HDR.TERRITORY_ID
, HDR.CUSTOMER_REF_DATE
, HDR.CUSTOMER_REF_NUMBER
, HDR.ASSIGNED_TO
, HDR.RECEIPT_ID
, HDR.RECEIPT_NUMBER
, HDR.DOC_SEQUENCE_ID
, HDR.DOC_SEQUENCE_VALUE
, HDR.PAYMENT_METHOD
, HDR.VOUCHER_ID
, HDR.VOUCHER_NUMBER
, HDR.PAYMENT_REFERENCE_ID
, HDR.PAYMENT_REFERENCE_NUMBER
, HDR.PAYMENT_REFERENCE_DATE
, HDR.PAYMENT_STATUS
, HDR.APPROVED_FLAG
, HDR.APPROVED_DATE
, HDR.APPROVED_BY
, HDR.SETTLED_DATE
, HDR.SETTLED_BY
, HDR.ATTRIBUTE_CATEGORY
, HDR.ATTRIBUTE1
, HDR.ATTRIBUTE2
, HDR.ATTRIBUTE3
, HDR.ATTRIBUTE4
, HDR.ATTRIBUTE5
, HDR.AMOUNT_ADJUSTED
, HDR.AMOUNT_REMAINING
, HDR.AMOUNT_SETTLED
, HDR.USER_STATUS_ID
, HDR.CLAIM_CLASS
, HDR.OWNER_ID
, HDR.HISTORY_EVENT
, HDR.HISTORY_EVENT_DATE
, HDR.HISTORY_EVENT_DESCRIPTION
, HDR.DUPLICATE_CLAIM_ID
, HDR.SPLIT_DATE
, HDR.ROOT_CLAIM_ID
, HDR.CLAIM_ID
, HDR.ACCTD_AMOUNT_REMAINING
, HDR.TAX_AMOUNT
, HDR.TAX_CODE
, HDR.TAX_CALCULATION_FLAG
, HDR.CUST_SHIPTO_ACCT_SITE_ID
, HDR.PAY_RELATED_ACCOUNT_FLAG
, HDR.RELATED_CUST_ACCOUNT_ID
, HDR.RELATED_SITE_USE_ID
, HDR.RELATIONSHIP_TYPE
, HDR.VENDOR_ID
, HDR.VENDOR_SITE_ID
, HDR.TASK_TEMPLATE_GROUP_ID
, HDR.GL_DATE
, HDR.EFFECTIVE_DATE
, HDR.CUSTOM_SETUP_ID
, HDR.TASK_ID
, HDR.COUNTRY_ID
, HDR.COMMENTS
, HDR.ACCTD_AMOUNT_ADJUSTED
, HDR.ACCTD_AMOUNT_SETTLED
, HDR.ORDER_TYPE_ID
, LIN.INTERFACE_CLAIM_LINE_ID
, LIN.LINE_NUMBER
, LIN.SPLIT_FROM_CLAIM_LINE_ID
, LIN.AMOUNT
, LIN.ACCTD_AMOUNT
, LIN.CURRENCY_CODE
, LIN.EXCHANGE_RATE_TYPE
, LIN.EXCHANGE_RATE_DATE
, LIN.EXCHANGE_RATE
, LIN.SET_OF_BOOKS_ID
, LIN.VALID_FLAG
, LIN.SOURCE_OBJECT_ID
, LIN.SOURCE_OBJECT_CLASS
, LIN.SOURCE_OBJECT_TYPE_ID
, LIN.PLAN_ID
, LIN.OFFER_ID
, LIN.PAYMENT_METHOD
, LIN.PAYMENT_REFERENCE_ID
, LIN.PAYMENT_REFERENCE_NUMBER
, LIN.PAYMENT_REFERENCE_DATE
, LIN.VOUCHER_ID
, LIN.VOUCHER_NUMBER
, LIN.PAYMENT_STATUS
, LIN.APPROVED_FLAG
, LIN.APPROVED_DATE
, LIN.APPROVED_BY
, LIN.SETTLED_DATE
, LIN.SETTLED_BY
, LIN.PERFORMANCE_COMPLETE_FLAG
, LIN.PERFORMANCE_ATTACHED_FLAG
, LIN.UTILIZATION_ID
, LIN.CLAIM_CURRENCY_AMOUNT
, LIN.TAX_CODE
, LIN.ITEM_ID
, LIN.ITEM_DESCRIPTION
, LIN.QUANTITY
, LIN.QUANTITY_UOM
, LIN.RATE
, LIN.ACTIVITY_TYPE
, LIN.ACTIVITY_ID
, LIN.EARNINGS_ASSOCIATED_FLAG
, LIN.RELATED_CUST_ACCOUNT_ID
, LIN.RELATIONSHIP_TYPE
, LIN.COMMENTS
, LIN.SOURCE_OBJECT_LINE_ID
, LIN.SELECT_CUST_CHILDREN_FLAG
, LIN.BUY_GROUP_CUST_ACCOUNT_ID
, LIN.CREDIT_TO
FROM OZF_CLAIMS_INT_ALL HDR
, OZF_CLAIM_LINES_INT_ALL LIN
WHERE HDR.INTERFACE_CLAIM_ID = LIN.INTERFACE_CLAIM_ID