Table: OZF_CLAIMS_ALL

Product:	OZF - Trade Management
Description:	This table stores the Claim headers
Implementation/DBA Data:	OZF.OZF_CLAIMS_ALL

Primary Key: OZF_CLAIMS_ALL_PK

1. CLAIM_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OZF_CLAIMS_ALL		OZF_BATCHES_ALL	OZF_CLAIMS_ALL.BATCH_ID
OZF_CLAIMS_ALL		HZ_CUST_ACCOUNTS	OZF_CLAIMS_ALL.CUST_ACCOUNT_ID
OZF_CLAIMS_ALL		HZ_PARTIES	OZF_CLAIMS_ALL.CONTACT_ID
OZF_CLAIMS_ALL		HZ_CUST_SITE_USES_ALL	OZF_CLAIMS_ALL.CUST_BILLTO_ACCT_SITE_ID
OZF_CLAIMS_ALL		HZ_CUST_SITE_USES_ALL	OZF_CLAIMS_ALL.CUST_SHIPTO_ACCT_SITE_ID
OZF_CLAIMS_ALL		HZ_LOCATIONS	OZF_CLAIMS_ALL.LOCATION_ID
OZF_CLAIMS_ALL		HZ_CUST_SITE_USES_ALL	OZF_CLAIMS_ALL.RELATED_SITE_USE_ID
OZF_CLAIMS_ALL		HZ_CUST_ACCOUNTS	OZF_CLAIMS_ALL.RELATED_CUST_ACCOUNT_ID
OZF_CLAIMS_ALL		OE_ORDER_HEADERS_ALL	OZF_CLAIMS_ALL.PAYMENT_REFERENCE_ID
OZF_CLAIMS_ALL		OZF_SYS_PARAMETERS_ALL	OZF_CLAIMS_ALL.SET_OF_BOOKS_ID
OZF_CLAIMS_ALL		OZF_REQUEST_HEADERS_ALL_B	OZF_CLAIMS_ALL.SOURCE_OBJECT_ID
OZF_CLAIMS_ALL		OZF_CLAIMS_ALL	OZF_CLAIMS_ALL.SPLIT_FROM_CLAIM_ID
OZF_CLAIMS_ALL		OZF_CLAIM_TYPES_ALL_B	OZF_CLAIMS_ALL.CLAIM_TYPE_ID
OZF_CLAIMS_ALL		OZF_REASON_CODES_ALL_B	OZF_CLAIMS_ALL.REASON_CODE_ID
OZF_CLAIMS_ALL		JTF_TASK_TEMP_GROUPS_B	OZF_CLAIMS_ALL.TASK_TEMPLATE_GROUP_ID
OZF_CLAIMS_ALL		PO_VENDORS	OZF_CLAIMS_ALL.VENDOR_ID
OZF_CLAIMS_ALL		PO_VENDOR_SITES_ALL	OZF_CLAIMS_ALL.VENDOR_SITE_ID
OZF_ACCTNG_EVENTS_ALL		OZF_CLAIMS_ALL	OZF_ACCTNG_EVENTS_ALL.SOURCE_ID
OZF_CLAIMS_ALL		OZF_CLAIMS_ALL	OZF_CLAIMS_ALL.SPLIT_FROM_CLAIM_ID
OZF_CLAIMS_HISTORY_ALL		OZF_CLAIMS_ALL	OZF_CLAIMS_HISTORY_ALL.CLAIM_ID
OZF_CLAIM_ADJUSTMENTS_ALL		OZF_CLAIMS_ALL	OZF_CLAIM_ADJUSTMENTS_ALL.CLAIM_ID
OZF_CLAIM_LINES_ALL		OZF_CLAIMS_ALL	OZF_CLAIM_LINES_ALL.CLAIM_ID
OZF_CLAIM_OFFER_PERF_ALL		OZF_CLAIMS_ALL	OZF_CLAIM_OFFER_PERF_ALL.CLAIM_ID
OZF_FUNDS_PAID_ALL		OZF_CLAIMS_ALL	OZF_FUNDS_PAID_ALL.CLAIM_ID
OZF_MC_TRANSACTIONS_ALL		OZF_CLAIMS_ALL	OZF_MC_TRANSACTIONS_ALL.SOURCE_OBJECT_ID