• Home
• org.kuali.ole
• ole-master-sql
• 1.5.8
• source code
• ole-master-sql-constraints.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.mysql.ole-master-sql-constraints.sql Maven / Gradle / Ivy

ALTER TABLE AP_AUTO_APRV_EXCL_T
    ADD CONSTRAINT AP_AUTO_APRV_EXCL_TR1
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AP_AUTO_APRV_EXCL_T
    ADD CONSTRAINT AP_AUTO_APRV_EXCL_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AP_CRDT_MEMO_ACCT_CHG_T
    ADD CONSTRAINT AP_CRDT_MEMO_ACCT_CHG_TR2
    FOREIGN KEY (CRDT_MEMO_ITM_ID)
    REFERENCES AP_CRDT_MEMO_ITM_T (CRDT_MEMO_ITM_ID)
/

ALTER TABLE AP_CRDT_MEMO_ACCT_CHG_T
    ADD CONSTRAINT AP_CRDT_MEMO_ACCT_CHG_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AP_CRDT_MEMO_ACCT_CHG_T
    ADD CONSTRAINT AP_CRDT_MEMO_ACCT_CHG_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AP_CRDT_MEMO_ACCT_CHG_T
    ADD CONSTRAINT AP_CRDT_MEMO_ACCT_CHG_TR5
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AP_CRDT_MEMO_ACCT_CHG_T
    ADD CONSTRAINT AP_CRDT_MEMO_ACCT_CHG_TR6
    FOREIGN KEY (FDOC_POST_YR, FDOC_POST_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE AP_CRDT_MEMO_ACCT_T
    ADD CONSTRAINT AP_CRDT_MEMO_ACCT_TR1
    FOREIGN KEY (CRDT_MEMO_ITM_ID)
    REFERENCES AP_CRDT_MEMO_ITM_T (CRDT_MEMO_ITM_ID)
/

ALTER TABLE AP_CRDT_MEMO_ACCT_T
    ADD CONSTRAINT AP_CRDT_MEMO_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AP_CRDT_MEMO_ACCT_T
    ADD CONSTRAINT AP_CRDT_MEMO_ACCT_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AP_CRDT_MEMO_ACCT_T
    ADD CONSTRAINT AP_CRDT_MEMO_ACCT_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AP_CRDT_MEMO_ITM_T
    ADD CONSTRAINT AP_CRDT_MEMO_ITM_TR1
    FOREIGN KEY (CRDT_MEMO_ID)
    REFERENCES AP_CRDT_MEMO_T (CRDT_MEMO_ID)
/

ALTER TABLE AP_CRDT_MEMO_ITM_T
    ADD CONSTRAINT AP_CRDT_MEMO_ITM_TR2
    FOREIGN KEY (ITM_TYP_CD)
    REFERENCES PUR_AP_ITM_TYP_T (ITM_TYP_CD)
/

ALTER TABLE AP_CRDT_MEMO_T
    ADD CONSTRAINT AP_CRDT_MEMO_TR1
    FOREIGN KEY (BNK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE AP_CRDT_MEMO_T
    ADD CONSTRAINT AP_CRDT_MEMO_TR3
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE AP_CRDT_MEMO_T
    ADD CONSTRAINT AP_CRDT_MEMO_TR6
    FOREIGN KEY (PMT_RQST_ID)
    REFERENCES AP_PMT_RQST_T (PMT_RQST_ID)
/

ALTER TABLE AP_CRDT_MEMO_T
    ADD CONSTRAINT AP_CRDT_MEMO_TR7
    FOREIGN KEY (CRDT_MEMO_STAT_CD)
    REFERENCES AP_CRDT_MEMO_STAT_T (CRDT_MEMO_STAT_CD)
/

ALTER TABLE AP_CRDT_MEMO_T
    ADD CONSTRAINT CRDT_MEMO_INV_SUB_TYP_FK
    FOREIGN KEY (CRDT_MEMO_INV_SUB_TYP_ID)
    REFERENCES OLE_INV_SUB_TYP_T (OLE_INV_SUB_TYP_ID)
/

ALTER TABLE AP_CRDT_MEMO_T
    ADD CONSTRAINT CRDT_MEMO_INV_TYP_FK
    FOREIGN KEY (CRDT_MEMO_INV_TYP_ID)
    REFERENCES OLE_INV_TYP_T (OLE_INV_TYP_ID)
/

ALTER TABLE AP_CRDT_MEMO_T
    ADD CONSTRAINT CRDT_PMT_MTHD_ID_FK
    FOREIGN KEY (CRDT_PMT_MTHD_ID)
    REFERENCES OLE_PMT_MTHD_T (OLE_PMT_MTHD_ID)
/

ALTER TABLE AP_ELCTRNC_INV_RJT_DOC_T
    ADD CONSTRAINT AP_ELCTRNC_INV_RJT_DOC_TR2
    FOREIGN KEY (INV_LOAD_SUM_ID, VNDR_DUNS_NBR)
    REFERENCES AP_ELCTRNC_INV_LOAD_SUM_T (INV_LOAD_SUM_ID, VNDR_DUNS_NBR)
/

ALTER TABLE AP_ELCTRNC_INV_RJT_ITM_T
    ADD CONSTRAINT AP_ELCTRNC_INV_RJT_ITM_TR1
    FOREIGN KEY (INV_RJT_ID)
    REFERENCES AP_ELCTRNC_INV_RJT_DOC_T (INV_RJT_ID)
/

ALTER TABLE AP_ELCTRNC_INV_RJT_REAS_T
    ADD CONSTRAINT AP_ELCTRNC_INV_RJT_REAS_TR1
    FOREIGN KEY (INV_RJT_ID)
    REFERENCES AP_ELCTRNC_INV_RJT_DOC_T (INV_RJT_ID)
/

ALTER TABLE AP_ELCTRNC_INV_RJT_REAS_T
    ADD CONSTRAINT AP_ELCTRNC_INV_RJT_REAS_TR2
    FOREIGN KEY (INV_RJT_REAS_TYP_CD)
    REFERENCES AP_ELCTRNC_INV_RJT_REAS_TYP_T (INV_RJT_REAS_TYP_CD)
/

ALTER TABLE AP_NEG_PMT_RQST_APRVL_LMT_T
    ADD CONSTRAINT AP_NEG_PMT_RQST_APRVL_LMT_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AP_NEG_PMT_RQST_APRVL_LMT_T
    ADD CONSTRAINT AP_NEG_PMT_RQST_APRVL_LMT_TR2
    FOREIGN KEY (FIN_COA_CD, ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AP_NEG_PMT_RQST_APRVL_LMT_T
    ADD CONSTRAINT AP_NEG_PMT_RQST_APRVL_LMT_TR3
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE AP_PMT_RQST_ACCT_CHG_T
    ADD CONSTRAINT AP_PMT_RQST_ACCT_CHG_TR2
    FOREIGN KEY (PMT_RQST_ITM_ID)
    REFERENCES AP_PMT_RQST_ITM_T (PMT_RQST_ITM_ID)
/

ALTER TABLE AP_PMT_RQST_ACCT_CHG_T
    ADD CONSTRAINT AP_PMT_RQST_ACCT_CHG_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AP_PMT_RQST_ACCT_CHG_T
    ADD CONSTRAINT AP_PMT_RQST_ACCT_CHG_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AP_PMT_RQST_ACCT_CHG_T
    ADD CONSTRAINT AP_PMT_RQST_ACCT_CHG_TR5
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AP_PMT_RQST_ACCT_CHG_T
    ADD CONSTRAINT AP_PMT_RQST_ACCT_CHG_TR6
    FOREIGN KEY (FDOC_POST_YR, FDOC_POST_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE AP_PMT_RQST_ACCT_T
    ADD CONSTRAINT AP_PMT_RQST_ACCT_TR1
    FOREIGN KEY (PMT_RQST_ITM_ID)
    REFERENCES AP_PMT_RQST_ITM_T (PMT_RQST_ITM_ID)
/

ALTER TABLE AP_PMT_RQST_ACCT_T
    ADD CONSTRAINT AP_PMT_RQST_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AP_PMT_RQST_ACCT_T
    ADD CONSTRAINT AP_PMT_RQST_ACCT_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AP_PMT_RQST_ACCT_T
    ADD CONSTRAINT AP_PMT_RQST_ACCT_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AP_PMT_RQST_ITM_T
    ADD CONSTRAINT AP_PMT_RQST_ITM_TR1
    FOREIGN KEY (PMT_RQST_ID)
    REFERENCES AP_PMT_RQST_T (PMT_RQST_ID)
/

ALTER TABLE AP_PMT_RQST_ITM_T
    ADD CONSTRAINT AP_PMT_RQST_ITM_TR2
    FOREIGN KEY (ITM_TYP_CD)
    REFERENCES PUR_AP_ITM_TYP_T (ITM_TYP_CD)
/

ALTER TABLE AP_PMT_RQST_ITM_T
    ADD CONSTRAINT AP_PMT_RQST_ITM_TR3
    FOREIGN KEY (OLE_FRMT_ID)
    REFERENCES OLE_PUR_FRMT_T (OLE_FRMT_ID)
/

ALTER TABLE AP_PMT_RQST_ITM_T
    ADD CONSTRAINT AP_PMT_RQST_ITM_TR4
    FOREIGN KEY (OLE_REQ_RCPT_STATUS_ID)
    REFERENCES OLE_PUR_REQ_RCPT_STATUS_T (OLE_REQ_RCPT_STATUS_ID)
/

ALTER TABLE AP_PMT_RQST_T
    ADD CONSTRAINT AP_PMT_RQST_TR1
    FOREIGN KEY (BNK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE AP_PMT_RQST_T
    ADD CONSTRAINT AP_PMT_RQST_TR10
    FOREIGN KEY (OLE_PMT_MTHD_ID)
    REFERENCES OLE_PMT_MTHD_T (OLE_PMT_MTHD_ID)
/

ALTER TABLE AP_PMT_RQST_T
    ADD CONSTRAINT AP_PMT_RQST_TR2
    FOREIGN KEY (PMT_RQST_STAT_CD)
    REFERENCES AP_PMT_RQST_STAT_T (PMT_RQST_STAT_CD)
/

ALTER TABLE AP_PMT_RQST_T
    ADD CONSTRAINT AP_PMT_RQST_TR3
    FOREIGN KEY (OLE_INV_TYP_ID)
    REFERENCES OLE_INV_TYP_T (OLE_INV_TYP_ID)
/

ALTER TABLE AP_PMT_RQST_T
    ADD CONSTRAINT AP_PMT_RQST_TR4
    FOREIGN KEY (OLE_INV_SUB_TYP_ID)
    REFERENCES OLE_INV_SUB_TYP_T (OLE_INV_SUB_TYP_ID)
/

ALTER TABLE AP_PMT_RQST_T
    ADD CONSTRAINT AP_PMT_RQST_TR5
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE AP_PMT_RQST_T
    ADD CONSTRAINT AP_PMT_RQST_TR6
    FOREIGN KEY (VNDR_SHP_PMT_TERM_CD)
    REFERENCES PUR_SHP_PMT_TERM_T (VNDR_SHP_PMT_TERM_CD)
/

ALTER TABLE AP_PMT_RQST_T
    ADD CONSTRAINT AP_PMT_RQST_TR7
    FOREIGN KEY (VNDR_PMT_TERMS_CD)
    REFERENCES PUR_PMT_TERM_TYP_T (VNDR_PMT_TERM_CD)
/

ALTER TABLE AP_PMT_RQST_T
    ADD CONSTRAINT AP_PMT_RQST_TR9
    FOREIGN KEY (PMT_RQST_CST_SRC_CD)
    REFERENCES PUR_PO_CST_SRC_T (PO_CST_SRC_CD)
/

ALTER TABLE AP_SUM_ACCT_T
    ADD CONSTRAINT AP_SUM_ACCT_TR1
    FOREIGN KEY (PMT_RQST_ID)
    REFERENCES AP_PMT_RQST_T (PMT_RQST_ID)
/

ALTER TABLE AP_SUM_ACCT_T
    ADD CONSTRAINT AP_SUM_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AP_SUM_ACCT_T
    ADD CONSTRAINT AP_SUM_ACCT_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AP_SUM_ACCT_T
    ADD CONSTRAINT AP_SUM_ACCT_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AP_SUM_ACCT_T
    ADD CONSTRAINT AP_SUM_ACCT_TR6
    FOREIGN KEY (CRDT_MEMO_ID)
    REFERENCES AP_CRDT_MEMO_T (CRDT_MEMO_ID)
/

ALTER TABLE AR_CRDT_MEMO_DTL_T
    ADD CONSTRAINT AR_CRDT_MEMO_DTL_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES AR_CRDT_MEMO_DOC_T (FDOC_NBR)
/

ALTER TABLE AR_CSH_CTRL_DTL_T
    ADD CONSTRAINT AR_CSH_CTRL_DTL_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES AR_CSH_CTRL_T (FDOC_NBR)
/

ALTER TABLE AR_CSH_CTRL_DTL_T
    ADD CONSTRAINT AR_CSH_CTRL_DTL_TR3
    FOREIGN KEY (CUST_NBR)
    REFERENCES AR_CUST_T (CUST_NBR)
/

ALTER TABLE AR_CSH_CTRL_T
    ADD CONSTRAINT AR_CSH_CTRL_TR1
    FOREIGN KEY (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE AR_CSH_CTRL_T
    ADD CONSTRAINT AR_CSH_CTRL_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES AR_DOC_HDR_T (FDOC_NBR)
/

ALTER TABLE AR_CSH_CTRL_T
    ADD CONSTRAINT AR_CSH_CTRL_TR3
    FOREIGN KEY (BNK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE AR_CUST_ADDR_T
    ADD CONSTRAINT AR_CUST_ADDR_TR1
    FOREIGN KEY (CUST_ADDR_TYPE_CD)
    REFERENCES AR_CUST_ADDR_TYP_T (CUST_ADDR_TYPE_CD)
/

ALTER TABLE AR_CUST_ADDR_T
    ADD CONSTRAINT AR_CUST_ADDR_TR2
    FOREIGN KEY (CUST_NBR)
    REFERENCES AR_CUST_T (CUST_NBR)
/

ALTER TABLE AR_CUST_BILLING_STMT_T
    ADD CONSTRAINT AR_CUST_BILLING_STMT_TR1
    FOREIGN KEY (CUST_NBR)
    REFERENCES AR_CUST_T (CUST_NBR)
/

ALTER TABLE AR_CUST_T
    ADD CONSTRAINT AR_CUST_TR1
    FOREIGN KEY (CUST_PARENT_CO_NBR)
    REFERENCES AR_CUST_T (CUST_NBR)
/

ALTER TABLE AR_CUST_T
    ADD CONSTRAINT AR_CUST_TR2
    FOREIGN KEY (CUST_TYP_CD)
    REFERENCES AR_CUST_TYP_T (CUST_TYP_CD)
/

ALTER TABLE AR_DOC_HDR_T
    ADD CONSTRAINT AR_DOC_HDR_TR2
    FOREIGN KEY (CUST_NBR)
    REFERENCES AR_CUST_T (CUST_NBR)
/

ALTER TABLE AR_DOC_HDR_T
    ADD CONSTRAINT AR_DOC_HDR_TR3
    FOREIGN KEY (PRCS_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_DOC_HDR_T
    ADD CONSTRAINT AR_DOC_HDR_TR4
    FOREIGN KEY (PRCS_FIN_COA_CD, PRCS_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE AR_DOC_RCURRNC_T
    ADD CONSTRAINT AR_DOC_RCURRNC_TR2
    FOREIGN KEY (CUST_NBR)
    REFERENCES AR_CUST_T (CUST_NBR)
/

ALTER TABLE AR_INV_DOC_T
    ADD CONSTRAINT AR_INV_DOC_TR1
    FOREIGN KEY (CUST_SPCL_PRCS_CD)
    REFERENCES AR_CUST_PRCS_TYP_T (CUST_SPCL_PRCS_CD)
/

ALTER TABLE AR_INV_DOC_T
    ADD CONSTRAINT AR_INV_DOC_TR11
    FOREIGN KEY (PMT_PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE AR_INV_DOC_T
    ADD CONSTRAINT AR_INV_DOC_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES AR_DOC_HDR_T (FDOC_NBR)
/

ALTER TABLE AR_INV_DOC_T
    ADD CONSTRAINT AR_INV_DOC_TR3
    FOREIGN KEY (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE AR_INV_DOC_T
    ADD CONSTRAINT AR_INV_DOC_TR4
    FOREIGN KEY (AR_BILL_BY_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_INV_DOC_T
    ADD CONSTRAINT AR_INV_DOC_TR5
    FOREIGN KEY (AR_BILL_BY_COA_CD, AR_BILL_BY_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE AR_INV_DOC_T
    ADD CONSTRAINT AR_INV_DOC_TR6
    FOREIGN KEY (PMT_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_INV_DOC_T
    ADD CONSTRAINT AR_INV_DOC_TR7
    FOREIGN KEY (PMT_FIN_COA_CD, PMT_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_INV_DOC_T
    ADD CONSTRAINT AR_INV_DOC_TR8
    FOREIGN KEY (PMT_FIN_COA_CD, PMT_ACCT_NBR, PMT_SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AR_INV_DTL_T
    ADD CONSTRAINT AR_INV_DTL_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES AR_INV_DOC_T (FDOC_NBR)
/

ALTER TABLE AR_INV_DTL_T
    ADD CONSTRAINT AR_INV_DTL_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_INV_DTL_T
    ADD CONSTRAINT AR_INV_DTL_TR4
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_INV_DTL_T
    ADD CONSTRAINT AR_INV_DTL_TR6
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AR_INV_DTL_T
    ADD CONSTRAINT AR_INV_DTL_TR9
    FOREIGN KEY (PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE AR_INV_ITM_CODE_T
    ADD CONSTRAINT AR_INV_ITM_CODE_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_INV_ITM_CODE_T
    ADD CONSTRAINT AR_INV_ITM_CODE_TR2
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE AR_INV_ITM_CODE_T
    ADD CONSTRAINT AR_INV_ITM_CODE_TR3
    FOREIGN KEY (INV_FIN_COA_CD, INV_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_INV_ITM_CODE_T
    ADD CONSTRAINT AR_INV_ITM_CODE_TR4
    FOREIGN KEY (INV_FIN_COA_CD, INV_ACCT_NBR, INV_SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AR_INV_ITM_CODE_T
    ADD CONSTRAINT AR_INV_ITM_CODE_TR5
    FOREIGN KEY (INV_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_INV_ITM_CODE_T
    ADD CONSTRAINT AR_INV_ITM_CODE_TR6
    FOREIGN KEY (INV_PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE AR_INV_PD_APLD_MT
    ADD CONSTRAINT AR_INV_PD_APLD_MTR1
    FOREIGN KEY (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE AR_INV_PD_APLD_T
    ADD CONSTRAINT AR_INV_PD_APLD_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES AR_DOC_HDR_T (FDOC_NBR)
/

ALTER TABLE AR_INV_PD_APLD_T
    ADD CONSTRAINT AR_INV_PD_APLD_TR2
    FOREIGN KEY (FDOC_REF_INV_NBR, AR_INV_ITM_NBR)
    REFERENCES AR_INV_DTL_T (FDOC_NBR, AR_INV_ITM_NBR)
/

ALTER TABLE AR_INV_PD_APLD_T
    ADD CONSTRAINT AR_INV_PD_APLD_TR3
    FOREIGN KEY (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE AR_LOCKBOX_T
    ADD CONSTRAINT AR_LOCKBOX_TR1
    FOREIGN KEY (CUST_PMT_MEDIUM_CD)
    REFERENCES AR_PMT_MEDIUM_T (CUST_PMT_MEDIUM_CD)
/

ALTER TABLE AR_LOCKBOX_T
    ADD CONSTRAINT AR_LOCKBOX_TR2
    FOREIGN KEY (BNK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE AR_NON_APLD_DIST_MT
    ADD CONSTRAINT AR_NON_APLD_DIST_MTR1
    FOREIGN KEY (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE AR_NON_APLD_DIST_T
    ADD CONSTRAINT AR_NON_APLD_DIST_TR1
    FOREIGN KEY (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE AR_NON_APLD_DIST_T
    ADD CONSTRAINT AR_NON_APLD_DIST_TR2
    FOREIGN KEY (FDOC_REF_NBR)
    REFERENCES AR_NON_APLD_HLDG_T (FDOC_REF_NBR)
/

ALTER TABLE AR_NON_APLD_HLDG_T
    ADD CONSTRAINT AR_NON_APLD_HLDG_TR1
    FOREIGN KEY (CUST_NBR)
    REFERENCES AR_CUST_T (CUST_NBR)
/

ALTER TABLE AR_NON_APLD_HLDG_T
    ADD CONSTRAINT AR_NON_APLD_HLDG_TR2
    FOREIGN KEY (FDOC_REF_NBR)
    REFERENCES AR_DOC_HDR_T (FDOC_NBR)
/

ALTER TABLE AR_NON_INV_DIST_MT
    ADD CONSTRAINT AR_NON_INV_DIST_MTR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES AR_DOC_HDR_T (FDOC_NBR)
/

ALTER TABLE AR_NON_INV_DIST_T
    ADD CONSTRAINT AR_NON_INV_DIST_TR1
    FOREIGN KEY (FDOC_REF_NBR)
    REFERENCES AR_NON_APLD_HLDG_T (FDOC_REF_NBR)
/

ALTER TABLE AR_NON_INV_DIST_T
    ADD CONSTRAINT AR_NON_INV_DIST_TR3
    FOREIGN KEY (FDOC_NBR, FDOC_LINE_NBR)
    REFERENCES AR_NON_INV_T (FDOC_NBR, FDOC_LINE_NBR)
/

ALTER TABLE AR_NON_INV_MT
    ADD CONSTRAINT AR_NON_INV_MTR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_NON_INV_MT
    ADD CONSTRAINT AR_NON_INV_MTR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_NON_INV_MT
    ADD CONSTRAINT AR_NON_INV_MTR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AR_NON_INV_MT
    ADD CONSTRAINT AR_NON_INV_MTR4
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE AR_NON_INV_MT
    ADD CONSTRAINT AR_NON_INV_MTR5
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
    REFERENCES CA_SUB_OBJECT_CD_T (UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
/

ALTER TABLE AR_NON_INV_MT
    ADD CONSTRAINT AR_NON_INV_MTR6
    FOREIGN KEY (PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE AR_NON_INV_T
    ADD CONSTRAINT AR_NON_INV_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES AR_DOC_HDR_T (FDOC_NBR)
/

ALTER TABLE AR_NON_INV_T
    ADD CONSTRAINT AR_NON_INV_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_NON_INV_T
    ADD CONSTRAINT AR_NON_INV_TR4
    FOREIGN KEY (PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE AR_NON_INV_T
    ADD CONSTRAINT AR_NON_INV_TR5
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_NON_INV_T
    ADD CONSTRAINT AR_NON_INV_TR6
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AR_OPEN_INV_DTL_MT
    ADD CONSTRAINT AR_OPEN_INV_DTL_MTR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_OPEN_INV_DTL_MT
    ADD CONSTRAINT AR_OPEN_INV_DTL_MTR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_OPEN_INV_DTL_MT
    ADD CONSTRAINT AR_OPEN_INV_DTL_MTR3
    FOREIGN KEY (AR_BILL_BY_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_OPEN_INV_DTL_MT
    ADD CONSTRAINT AR_OPEN_INV_DTL_MTR4
    FOREIGN KEY (AR_BILL_BY_COA_CD, AR_BILL_BY_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE AR_OPEN_INV_DTL_MT
    ADD CONSTRAINT AR_OPEN_INV_DTL_MTR5
    FOREIGN KEY (PRCS_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_OPEN_INV_DTL_MT
    ADD CONSTRAINT AR_OPEN_INV_DTL_MTR6
    FOREIGN KEY (PRCS_FIN_COA_CD, PRCS_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE AR_OPEN_INV_DTL_MT
    ADD CONSTRAINT AR_OPEN_INV_DTL_MTR7
    FOREIGN KEY (CUST_NBR)
    REFERENCES AR_CUST_T (CUST_NBR)
/

ALTER TABLE AR_OPEN_INV_DTL_MT
    ADD CONSTRAINT AR_OPEN_INV_DTL_MTR8
    FOREIGN KEY (FDOC_NBR, AR_INV_ITM_NBR)
    REFERENCES AR_INV_DTL_T (FDOC_NBR, AR_INV_ITM_NBR)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR1
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR10
    FOREIGN KEY (INV_FIN_COA_CD, INV_ACCT_NBR, INV_SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR11
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, ORG_LT_CHRG_OBJ_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR12
    FOREIGN KEY (UNIV_FISCAL_YR, INV_FIN_COA_CD, INV_FIN_OBJ_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR13
    FOREIGN KEY (UNIV_FISCAL_YR, INV_FIN_COA_CD, INV_ACCT_NBR, INV_FIN_OBJ_CD, INV_FIN_SUB_OBJ_CD)
    REFERENCES CA_SUB_OBJECT_CD_T (UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR14
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR15
    FOREIGN KEY (UNIV_FISCAL_YR, PMT_FIN_COA_CD, PMT_FIN_OBJ_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR16
    FOREIGN KEY (UNIV_FISCAL_YR, PMT_FIN_COA_CD, PMT_ACCT_NBR, PMT_FIN_OBJ_CD, PMT_FIN_SUB_OBJ_CD)
    REFERENCES CA_SUB_OBJECT_CD_T (UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR17
    FOREIGN KEY (WRITEOFF_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR18
    FOREIGN KEY (WRITEOFF_FIN_COA_CD, WRITEOFF_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR19
    FOREIGN KEY (WRITEOFF_FIN_COA_CD, WRITEOFF_ACCT_NBR, WRITEOFF_SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR20
    FOREIGN KEY (UNIV_FISCAL_YR, WRITEOFF_FIN_COA_CD, WRITEOFF_FIN_OBJ_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR21
    FOREIGN KEY (UNIV_FISCAL_YR, WRITEOFF_FIN_COA_CD, WRITEOFF_ACCT_NBR, WRITEOFF_FIN_OBJ_CD, WRITEOFF_FIN_SUB_OBJ_CD)
    REFERENCES CA_SUB_OBJECT_CD_T (UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR22
    FOREIGN KEY (WRITEOFF_PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR3
    FOREIGN KEY (INV_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR4
    FOREIGN KEY (PMT_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR5
    FOREIGN KEY (PMT_PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR6
    FOREIGN KEY (PMT_FIN_COA_CD, PMT_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR7
    FOREIGN KEY (INV_FIN_COA_CD, INV_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR8
    FOREIGN KEY (INV_PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE AR_ORG_ACCTGDFLT_T
    ADD CONSTRAINT AR_ORG_ACCTGDFLT_TR9
    FOREIGN KEY (PMT_FIN_COA_CD, PMT_ACCT_NBR, PMT_SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AR_ORG_OPTION_T
    ADD CONSTRAINT AR_ORG_OPTION_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_ORG_OPTION_T
    ADD CONSTRAINT AR_ORG_OPTION_TR2
    FOREIGN KEY (PRCS_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_ORG_OPTION_T
    ADD CONSTRAINT AR_ORG_OPTION_TR3
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE AR_ORG_OPTION_T
    ADD CONSTRAINT AR_ORG_OPTION_TR4
    FOREIGN KEY (PRCS_FIN_COA_CD, PRCS_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE AR_WRITEOFF_DOC_T
    ADD CONSTRAINT AR_WRITEOFF_DOC_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE AR_WRITEOFF_DOC_T
    ADD CONSTRAINT AR_WRITEOFF_DOC_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE AR_WRITEOFF_DOC_T
    ADD CONSTRAINT AR_WRITEOFF_DOC_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE AR_WRITEOFF_DOC_T
    ADD CONSTRAINT AR_WRITEOFF_DOC_TR5
    FOREIGN KEY (PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE AR_WRITEOFF_DOC_T
    ADD CONSTRAINT AR_WRITEOFF_DOC_TR6
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE AR_WRITEOFF_DOC_T
    ADD CONSTRAINT AR_WRITEOFF_DOC_TR7
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
    REFERENCES CA_SUB_OBJECT_CD_T (UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
/

ALTER TABLE CA_A21_SUB_ACCT_T
    ADD CONSTRAINT CA_A21_SUB_ACCT_TR1
    FOREIGN KEY (ICR_TYP_CD)
    REFERENCES CA_ICR_TYPE_T (ACCT_ICR_TYP_CD)
/

ALTER TABLE CA_A21_SUB_ACCT_T
    ADD CONSTRAINT CA_A21_SUB_ACCT_TR2
    FOREIGN KEY (ICR_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_A21_SUB_ACCT_T
    ADD CONSTRAINT CA_A21_SUB_ACCT_TR3
    FOREIGN KEY (ICR_FIN_COA_CD, ICR_ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CA_A21_SUB_ACCT_T
    ADD CONSTRAINT CA_A21_SUB_ACCT_TR4
    FOREIGN KEY (CST_SHR_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_A21_SUB_ACCT_T
    ADD CONSTRAINT CA_A21_SUB_ACCT_TR6
    FOREIGN KEY (CST_SHR_COA_CD, CST_SHRSRCACCT_NBR, CST_SRCSUBACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE CA_A21_SUB_ACCT_T
    ADD CONSTRAINT CA_A21_SUB_ACCT_TR7
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_A21_SUB_ACCT_T
    ADD CONSTRAINT CA_A21_SUB_ACCT_TR8
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR10
    FOREIGN KEY (CONT_FIN_COA_CD, CONT_ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR11
    FOREIGN KEY (ENDOW_FIN_COA_CD, ENDOW_ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR12
    FOREIGN KEY (ENDOW_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR14
    FOREIGN KEY (INCOME_FIN_COA_CD, INCOME_ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR15
    FOREIGN KEY (ACCT_ICR_TYP_CD)
    REFERENCES CA_ICR_TYPE_T (ACCT_ICR_TYP_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR16
    FOREIGN KEY (ICR_FIN_COA_CD, ICR_ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR2
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR20
    FOREIGN KEY (ACCT_SF_CD)
    REFERENCES CA_ACCT_SF_T (ACCT_SF_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR21
    FOREIGN KEY (BDGT_REC_LVL_CD)
    REFERENCES CA_BDGT_REC_LVL_T (BDGT_REC_LVL_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR24
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR3
    FOREIGN KEY (ACCT_TYP_CD)
    REFERENCES CA_ACCOUNT_TYPE_T (ACCT_TYP_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR6
    FOREIGN KEY (SUB_FUND_GRP_CD)
    REFERENCES CA_SUB_FUND_GRP_T (SUB_FUND_GRP_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR7
    FOREIGN KEY (FIN_HGH_ED_FUNC_CD)
    REFERENCES CA_HIGHR_ED_FUNC_T (FIN_HGH_ED_FUNC_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR8
    FOREIGN KEY (ACCT_RSTRC_STAT_CD)
    REFERENCES CA_RESTRICT_STAT_T (ACCT_RSTRC_STAT_CD)
/

ALTER TABLE CA_ACCOUNT_T
    ADD CONSTRAINT CA_ACCOUNT_TR9
    FOREIGN KEY (RPTS_TO_FIN_COA_CD, RPTS_TO_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CA_ACCT_CHG_DTL_T
    ADD CONSTRAINT CA_ACCT_CHG_DTL_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ACCT_CHG_DTL_T
    ADD CONSTRAINT CA_ACCT_CHG_DTL_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CA_ACCT_DELEGATE_T
    ADD CONSTRAINT CA_ACCT_DELEGATE_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ACCT_DELEGATE_T
    ADD CONSTRAINT CA_ACCT_DELEGATE_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CA_ACCT_DESC_T
    ADD CONSTRAINT CA_ACCT_DESC_TR1
    FOREIGN KEY (CAMPUS_CD, BLDG_CD)
    REFERENCES SH_BUILDING_T (CAMPUS_CD, BLDG_CD)
/

ALTER TABLE CA_CHART_T
    ADD CONSTRAINT CA_CHART_TR12
    FOREIGN KEY (RPTS_TO_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_HIGHR_ED_FUNC_T
    ADD CONSTRAINT CA_HIGHR_ED_FUNC_TR1
    FOREIGN KEY (FIN_UBO_FUNC_CD)
    REFERENCES CA_UBO_FUNC_T (FIN_UBO_FUNC_CD)
/

ALTER TABLE CA_HIGHR_ED_FUNC_T
    ADD CONSTRAINT CA_HIGHR_ED_FUNC_TR2
    FOREIGN KEY (FIN_FED_FUNC_CD)
    REFERENCES CA_FEDERAL_FUNC_T (FIN_FED_FUNC_CD)
/

ALTER TABLE CA_HIGHR_ED_FUNC_T
    ADD CONSTRAINT CA_HIGHR_ED_FUNC_TR3
    FOREIGN KEY (FIN_AICPA_FUNC_CD)
    REFERENCES CA_AICPA_FUNC_T (FIN_AICPA_FUNC_CD)
/

ALTER TABLE CA_ICR_AUTO_ENTR_T
    ADD CONSTRAINT CA_ICR_AUTO_ENTR_TR3
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_SERIES_ID)
    REFERENCES CA_ICR_RATE_T (UNIV_FISCAL_YR, FIN_SERIES_ID)
/

ALTER TABLE CA_ICR_EXCL_ACCT_T
    ADD CONSTRAINT CA_ICR_EXCL_ACCT_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ICR_EXCL_ACCT_T
    ADD CONSTRAINT CA_ICR_EXCL_ACCT_TR3
    FOREIGN KEY (FIN_OBJ_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ICR_EXCL_TYPE_T
    ADD CONSTRAINT CA_ICR_EXCL_TYPE_TR2
    FOREIGN KEY (ACCT_ICR_TYP_CD)
    REFERENCES CA_ICR_TYPE_T (ACCT_ICR_TYP_CD)
/

ALTER TABLE CA_ICR_RATE_T
    ADD CONSTRAINT CA_ICR_RATE_TR1
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR10
    FOREIGN KEY (FIN_OBJ_TYP_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR11
    FOREIGN KEY (FIN_OBJ_SUB_TYP_CD)
    REFERENCES CA_OBJ_SUB_TYPE_T (FIN_OBJ_SUB_TYP_CD)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR12
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR2
    FOREIGN KEY (FOBJ_BDGT_AGGR_CD)
    REFERENCES CA_BDGT_AGGR_T (FOBJ_BDGT_AGGR_CD)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR3
    FOREIGN KEY (FOBJ_MNXFR_ELIM_CD)
    REFERENCES CA_MNXFR_ELIM_T (FOBJ_MNXFR_ELIM_CD)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR4
    FOREIGN KEY (FIN_FED_FUNDED_CD)
    REFERENCES CA_FED_FND_T (FIN_FED_FUNDED_CD)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR5
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, NXT_YR_FIN_OBJ_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR6
    FOREIGN KEY (FIN_COA_CD, FIN_OBJ_LEVEL_CD)
    REFERENCES CA_OBJ_LEVEL_T (FIN_COA_CD, FIN_OBJ_LEVEL_CD)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR7
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_OBJECT_CODE_T
    ADD CONSTRAINT CA_OBJECT_CODE_TR8
    FOREIGN KEY (RPTS_TO_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_OBJ_CD_CHG_DTL_T
    ADD CONSTRAINT CA_OBJ_CD_CHG_DTL_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_OBJ_CD_CHG_DTL_T
    ADD CONSTRAINT CA_OBJ_CD_CHG_DTL_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES CA_OBJ_CD_CHG_DOC_T (FDOC_NBR)
/

ALTER TABLE CA_OBJ_CONSOLDTN_T
    ADD CONSTRAINT CA_OBJ_CONSOLDTN_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_OBJ_LEVEL_T
    ADD CONSTRAINT CA_OBJ_LEVEL_TR1
    FOREIGN KEY (FIN_COA_CD, FIN_CONS_OBJ_CD)
    REFERENCES CA_OBJ_CONSOLDTN_T (FIN_COA_CD, FIN_CONS_OBJ_CD)
/

ALTER TABLE CA_OBJ_LEVEL_T
    ADD CONSTRAINT CA_OBJ_LEVEL_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_OBJ_TYPE_T
    ADD CONSTRAINT CA_OBJ_TYPE_TR1
    FOREIGN KEY (ACCTG_CTGRY_CD)
    REFERENCES CA_ACCTG_CTGRY_T (ACCTG_CTGRY_CD)
/

ALTER TABLE CA_ORG_EXTNS_T
    ADD CONSTRAINT CA_ORG_EXTNS_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_REVERSION_T
    ADD CONSTRAINT CA_ORG_REVERSION_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_REVERSION_T
    ADD CONSTRAINT CA_ORG_REVERSION_TR2
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_ORG_REVERSION_T
    ADD CONSTRAINT CA_ORG_REVERSION_TR5
    FOREIGN KEY (BDGT_RVRSN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_REVERSION_T
    ADD CONSTRAINT CA_ORG_REVERSION_TR6
    FOREIGN KEY (CSH_RVRSNFINCOA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_REVERSION_T
    ADD CONSTRAINT CA_ORG_REVERSION_TR7
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE CA_ORG_RTNG_MDL_NM_T
    ADD CONSTRAINT CA_ORG_RTNG_MDL_NM_TR1
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_ORG_RTNG_MDL_NM_T
    ADD CONSTRAINT CA_ORG_RTNG_MDL_NM_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_RTNG_MDL_T
    ADD CONSTRAINT CA_ORG_RTNG_MDL_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_RTNG_MDL_T
    ADD CONSTRAINT CA_ORG_RTNG_MDL_TR2
    FOREIGN KEY (FIN_COA_CD, ORG_CD, ORG_RTNG_MDL_NM)
    REFERENCES CA_ORG_RTNG_MDL_NM_T (FIN_COA_CD, ORG_CD, ORG_RTNG_MDL_NM)
/

ALTER TABLE CA_ORG_RVRSN_CHG_DTL_T
    ADD CONSTRAINT CA_ORG_RVRSN_CHG_DTL_TR1
    FOREIGN KEY (ORG_RVRSN_CTGRY_CD)
    REFERENCES CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD)
/

ALTER TABLE CA_ORG_RVRSN_CHG_DTL_T
    ADD CONSTRAINT CA_ORG_RVRSN_CHG_DTL_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES CA_ORG_RVRSN_CHG_DOC_T (FDOC_NBR)
/

ALTER TABLE CA_ORG_RVRSN_CHG_ORG_T
    ADD CONSTRAINT CA_ORG_RVRSN_CHG_ORG_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_RVRSN_CHG_ORG_T
    ADD CONSTRAINT CA_ORG_RVRSN_CHG_ORG_TR2
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_ORG_RVRSN_CHG_ORG_T
    ADD CONSTRAINT CA_ORG_RVRSN_CHG_ORG_TR3
    FOREIGN KEY (FDOC_NBR)
    REFERENCES CA_ORG_RVRSN_CHG_DOC_T (FDOC_NBR)
/

ALTER TABLE CA_ORG_RVRSN_DTL_T
    ADD CONSTRAINT CA_ORG_RVRSN_DTL_TR1
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, ORG_RVRSN_OBJ_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE CA_ORG_RVRSN_DTL_T
    ADD CONSTRAINT CA_ORG_RVRSN_DTL_TR2
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE CA_ORG_RVRSN_DTL_T
    ADD CONSTRAINT CA_ORG_RVRSN_DTL_TR3
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_ORG_RVRSN_DTL_T
    ADD CONSTRAINT CA_ORG_RVRSN_DTL_TR4
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_RVRSN_DTL_T
    ADD CONSTRAINT CA_ORG_RVRSN_DTL_TR5
    FOREIGN KEY (ORG_RVRSN_CTGRY_CD)
    REFERENCES CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD)
/

ALTER TABLE CA_ORG_RVRSN_DTL_T
    ADD CONSTRAINT CA_ORG_RVRSN_DTL_TR6
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_REVERSION_T (UNIV_FISCAL_YR, FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_ORG_T
    ADD CONSTRAINT CA_ORG_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_T
    ADD CONSTRAINT CA_ORG_TR11
    FOREIGN KEY (ORG_PLNT_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_T
    ADD CONSTRAINT CA_ORG_TR12
    FOREIGN KEY (CMP_PLNT_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_ORG_T
    ADD CONSTRAINT CA_ORG_TR4
    FOREIGN KEY (RC_CD)
    REFERENCES CA_RC_T (RC_CD)
/

ALTER TABLE CA_ORG_T
    ADD CONSTRAINT CA_ORG_TR6
    FOREIGN KEY (ORG_TYP_CD)
    REFERENCES CA_ORG_TYPE_T (ORG_TYP_CD)
/

ALTER TABLE CA_ORG_T
    ADD CONSTRAINT CA_ORG_TR7
    FOREIGN KEY (RPTS_TO_FIN_COA_CD, RPTS_TO_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_ORG_T
    ADD CONSTRAINT CA_ORG_TR8
    FOREIGN KEY (RPTS_TO_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_PRIOR_YR_ACCT_T
    ADD CONSTRAINT CA_PRIOR_YR_ACCT_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_PRIOR_YR_ACCT_T
    ADD CONSTRAINT CA_PRIOR_YR_ACCT_TR3
    FOREIGN KEY (ACCT_TYP_CD)
    REFERENCES CA_ACCOUNT_TYPE_T (ACCT_TYP_CD)
/

ALTER TABLE CA_PRIOR_YR_ACCT_T
    ADD CONSTRAINT CA_PRIOR_YR_ACCT_TR6
    FOREIGN KEY (SUB_FUND_GRP_CD)
    REFERENCES CA_SUB_FUND_GRP_T (SUB_FUND_GRP_CD)
/

ALTER TABLE CA_PRIOR_YR_ACCT_T
    ADD CONSTRAINT CA_PRIOR_YR_ACCT_TR7
    FOREIGN KEY (FIN_HGH_ED_FUNC_CD)
    REFERENCES CA_HIGHR_ED_FUNC_T (FIN_HGH_ED_FUNC_CD)
/

ALTER TABLE CA_PRIOR_YR_ACCT_T
    ADD CONSTRAINT CA_PRIOR_YR_ACCT_TR8
    FOREIGN KEY (ACCT_RSTRC_STAT_CD)
    REFERENCES CA_RESTRICT_STAT_T (ACCT_RSTRC_STAT_CD)
/

ALTER TABLE CA_PRIOR_YR_ORG_T
    ADD CONSTRAINT CA_PRIOR_YR_ORG_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_PRIOR_YR_ORG_T
    ADD CONSTRAINT CA_PRIOR_YR_ORG_TR10
    FOREIGN KEY (CMP_PLNT_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_PRIOR_YR_ORG_T
    ADD CONSTRAINT CA_PRIOR_YR_ORG_TR3
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_PRIOR_YR_ORG_T
    ADD CONSTRAINT CA_PRIOR_YR_ORG_TR5
    FOREIGN KEY (RPTS_TO_FIN_COA_CD, RPTS_TO_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_PRIOR_YR_ORG_T
    ADD CONSTRAINT CA_PRIOR_YR_ORG_TR6
    FOREIGN KEY (RPTS_TO_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_PRIOR_YR_ORG_T
    ADD CONSTRAINT CA_PRIOR_YR_ORG_TR9
    FOREIGN KEY (ORG_PLNT_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_PROJECT_T
    ADD CONSTRAINT CA_PROJECT_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_PROJECT_T
    ADD CONSTRAINT CA_PROJECT_TR2
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_SUB_ACCT_T
    ADD CONSTRAINT CA_SUB_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_SUB_ACCT_T
    ADD CONSTRAINT CA_SUB_ACCT_TR3
    FOREIGN KEY (FIN_RPT_CHRT_CD, FIN_RPT_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CA_SUB_ACCT_T
    ADD CONSTRAINT CA_SUB_ACCT_TR4
    FOREIGN KEY (FIN_RPT_CHRT_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_SUB_FUND_GRP_T
    ADD CONSTRAINT CA_SUB_FUND_GRP_TR1
    FOREIGN KEY (FUND_GRP_CD)
    REFERENCES CA_FUND_GRP_T (FUND_GRP_CD)
/

ALTER TABLE CA_SUB_FUND_GRP_T
    ADD CONSTRAINT CA_SUB_FUND_GRP_TR2
    FOREIGN KEY (SUB_FUNDGRP_TYP_CD)
    REFERENCES CA_SUB_FND_GRP_TYP_T (SUB_FUNDGRP_TYP_CD)
/

ALTER TABLE CA_SUB_FUND_GRP_T
    ADD CONSTRAINT CA_SUB_FUND_GRP_TR3
    FOREIGN KEY (ACCT_RSTRC_STAT_CD)
    REFERENCES CA_RESTRICT_STAT_T (ACCT_RSTRC_STAT_CD)
/

ALTER TABLE CA_SUB_OBJECT_CD_T
    ADD CONSTRAINT CA_SUB_OBJECT_CD_TR1
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE CA_SUB_OBJECT_CD_T
    ADD CONSTRAINT CA_SUB_OBJECT_CD_TR2
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE CA_SUB_OBJECT_CD_T
    ADD CONSTRAINT CA_SUB_OBJECT_CD_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_SUB_OBJ_CD_CHG_DOC_T
    ADD CONSTRAINT CA_SUB_OBJ_CD_CHG_DOC_TR2
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE CA_SUB_OBJ_CD_CHG_DOC_T
    ADD CONSTRAINT CA_SUB_OBJ_CD_CHG_DOC_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CA_SUB_OBJ_CD_CHG_DTL_T
    ADD CONSTRAINT CA_SUB_OBJ_CD_CHG_DTL_TR1
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE CA_SUB_OBJ_CD_CHG_DTL_T
    ADD CONSTRAINT CA_SUB_OBJ_CD_CHG_DTL_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES CA_SUB_OBJ_CD_CHG_DOC_T (FDOC_NBR)
/

ALTER TABLE CA_SUB_OBJ_CD_CHG_DTL_T
    ADD CONSTRAINT CA_SUB_OBJ_CD_CHG_DTL_TR3
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE CA_SUB_OBJ_CD_CHG_DTL_T
    ADD CONSTRAINT CA_SUB_OBJ_CD_CHG_DTL_TR4
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CB_GL_ENTRY_AST_T
    ADD CONSTRAINT CB_GL_ENTRY_AST_TR1
    FOREIGN KEY (CB_GL_ACCT_ID)
    REFERENCES CB_GL_ENTRY_T (CB_GL_ACCT_ID)
/

ALTER TABLE CB_PRTG_DTL_T
    ADD CONSTRAINT CB_PRTG_DTL_TR2
    FOREIGN KEY (CAMPUS_CD, BLDG_CD)
    REFERENCES SH_BUILDING_T (CAMPUS_CD, BLDG_CD)
/

ALTER TABLE CB_PRTG_DTL_T
    ADD CONSTRAINT CB_PRTG_DTL_TR3
    FOREIGN KEY (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
    REFERENCES SH_ROOM_T (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
/

ALTER TABLE CB_PRTG_DTL_T
    ADD CONSTRAINT CB_PRTG_DTL_TR4
    FOREIGN KEY (PO_NUMBER, ITM_LN_NBR)
    REFERENCES CB_PRTG_T (PO_NUMBER, ITM_LN_NBR)
/

ALTER TABLE CB_PRTG_T
    ADD CONSTRAINT CB_PRTG_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CB_PRTG_T
    ADD CONSTRAINT CB_PRTG_TR2
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CB_PRTG_T
    ADD CONSTRAINT CB_PRTG_TR4
    FOREIGN KEY (CPTLAST_TYP_CD)
    REFERENCES CM_ASSET_TYPE_T (CPTLAST_TYP_CD)
/

ALTER TABLE CB_PUR_ITM_AST_T
    ADD CONSTRAINT CB_PUR_ITM_AST_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES CB_PUR_DOC_T (FDOC_NBR)
/

ALTER TABLE CB_PUR_LN_AST_ACCT_T
    ADD CONSTRAINT CB_PUR_LN_AST_ACCT_TR1
    FOREIGN KEY (FDOC_NBR, PUR_ITM_ID, CB_LN_NBR)
    REFERENCES CB_PUR_ITM_AST_T (FDOC_NBR, PUR_ITM_ID, CB_LN_NBR)
/

ALTER TABLE CB_PUR_LN_AST_ACCT_T
    ADD CONSTRAINT CB_PUR_LN_AST_ACCT_TR2
    FOREIGN KEY (CB_GL_ACCT_ID)
    REFERENCES CB_GL_ENTRY_T (CB_GL_ACCT_ID)
/

ALTER TABLE CG_AGENCY_T
    ADD CONSTRAINT CG_AGENCY_TR1
    FOREIGN KEY (CG_AGENCY_TYP_CD)
    REFERENCES CG_AGENCY_TYP_T (CG_AGENCY_TYP_CD)
/

ALTER TABLE CG_AGENCY_T
    ADD CONSTRAINT CG_AGENCY_TR2
    FOREIGN KEY (CG_RPTTO_AGNCY_NBR)
    REFERENCES CG_AGENCY_T (CG_AGENCY_NBR)
/

ALTER TABLE CG_AWD_ACCT_T
    ADD CONSTRAINT CG_AWD_ACCT_TR1
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CG_AWD_ACCT_T
    ADD CONSTRAINT CG_AWD_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CG_AWD_ACCT_T
    ADD CONSTRAINT CG_AWD_ACCT_TR4
    FOREIGN KEY (CGPRPSL_NBR)
    REFERENCES CG_AWD_T (CGPRPSL_NBR)
/

ALTER TABLE CG_AWD_ORG_T
    ADD CONSTRAINT CG_AWD_ORG_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CG_AWD_ORG_T
    ADD CONSTRAINT CG_AWD_ORG_TR3
    FOREIGN KEY (CGPRPSL_NBR)
    REFERENCES CG_AWD_T (CGPRPSL_NBR)
/

ALTER TABLE CG_AWD_PRJDR_T
    ADD CONSTRAINT CG_AWD_PRJDR_TR2
    FOREIGN KEY (CGPRPSL_NBR)
    REFERENCES CG_AWD_T (CGPRPSL_NBR)
/

ALTER TABLE CG_AWD_SUBCN_T
    ADD CONSTRAINT CG_AWD_SUBCN_TR1
    FOREIGN KEY (CG_SUBCNR_NBR)
    REFERENCES CG_SUBCNR_T (CG_SUBCNR_NBR)
/

ALTER TABLE CG_AWD_SUBCN_T
    ADD CONSTRAINT CG_AWD_SUBCN_TR2
    FOREIGN KEY (CGPRPSL_NBR)
    REFERENCES CG_AWD_T (CGPRPSL_NBR)
/

ALTER TABLE CG_AWD_T
    ADD CONSTRAINT CG_AWD_TR1
    FOREIGN KEY (CGPRPSL_NBR)
    REFERENCES CG_PRPSL_T (CGPRPSL_NBR)
/

ALTER TABLE CG_AWD_T
    ADD CONSTRAINT CG_AWD_TR2
    FOREIGN KEY (CGPRPSL_AWD_TYP_CD)
    REFERENCES CG_PRPSL_AWD_TYP_T (CGPRPSL_AWD_TYP_CD)
/

ALTER TABLE CG_AWD_T
    ADD CONSTRAINT CG_AWD_TR3
    FOREIGN KEY (CGAWD_STAT_CD)
    REFERENCES CG_AWD_STAT_T (CGAWD_STAT_CD)
/

ALTER TABLE CG_AWD_T
    ADD CONSTRAINT CG_AWD_TR4
    FOREIGN KEY (CG_LTRCR_FNDGRP_CD)
    REFERENCES CG_LTRCR_FNDGRP_T (CG_LTRCR_FNDGRP_CD)
/

ALTER TABLE CG_AWD_T
    ADD CONSTRAINT CG_AWD_TR5
    FOREIGN KEY (CG_GRANT_DESC_CD)
    REFERENCES CG_GRANT_DESC_T (CG_GRANT_DESC_CD)
/

ALTER TABLE CG_AWD_T
    ADD CONSTRAINT CG_AWD_TR6
    FOREIGN KEY (CG_AGENCY_NBR)
    REFERENCES CG_AGENCY_T (CG_AGENCY_NBR)
/

ALTER TABLE CG_AWD_T
    ADD CONSTRAINT CG_AWD_TR7
    FOREIGN KEY (CG_FEDPT_AGNCY_NBR)
    REFERENCES CG_AGENCY_T (CG_AGENCY_NBR)
/

ALTER TABLE CG_AWD_T
    ADD CONSTRAINT CG_AWD_TR8
    FOREIGN KEY (CGAWD_PURPOSE_CD)
    REFERENCES CG_PRPSL_PURPOSE_T (CGPRPSL_PURPOSE_CD)
/

ALTER TABLE CG_PRPSL_ORG_T
    ADD CONSTRAINT CG_PRPSL_ORG_TR1
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE CG_PRPSL_ORG_T
    ADD CONSTRAINT CG_PRPSL_ORG_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CG_PRPSL_ORG_T
    ADD CONSTRAINT CG_PRPSL_ORG_TR3
    FOREIGN KEY (CGPRPSL_NBR)
    REFERENCES CG_PRPSL_T (CGPRPSL_NBR)
/

ALTER TABLE CG_PRPSL_PRJDR_T
    ADD CONSTRAINT CG_PRPSL_PRJDR_TR2
    FOREIGN KEY (CGPRPSL_NBR)
    REFERENCES CG_PRPSL_T (CGPRPSL_NBR)
/

ALTER TABLE CG_PRPSL_RSRCH_RSK_T
    ADD CONSTRAINT CG_PRPSL_RSRCH_RSK_TR1
    FOREIGN KEY (CGPRPSL_NBR)
    REFERENCES CG_PRPSL_T (CGPRPSL_NBR)
/

ALTER TABLE CG_PRPSL_RSRCH_RSK_T
    ADD CONSTRAINT CG_PRPSL_RSRCH_RSK_TR2
    FOREIGN KEY (RSRCH_RSK_TYP_CD)
    REFERENCES ER_RSRCH_RSK_TYP_T (RSRCH_RSK_TYP_CD)
/

ALTER TABLE CG_PRPSL_SUBCN_T
    ADD CONSTRAINT CG_PRPSL_SUBCN_TR1
    FOREIGN KEY (CG_SUBCNR_NBR)
    REFERENCES CG_SUBCNR_T (CG_SUBCNR_NBR)
/

ALTER TABLE CG_PRPSL_SUBCN_T
    ADD CONSTRAINT CG_PRPSL_SUBCN_TR2
    FOREIGN KEY (CGPRPSL_NBR)
    REFERENCES CG_PRPSL_T (CGPRPSL_NBR)
/

ALTER TABLE CG_PRPSL_T
    ADD CONSTRAINT CG_PRPSL_TR2
    FOREIGN KEY (CGPRPSL_AWD_TYP_CD)
    REFERENCES CG_PRPSL_AWD_TYP_T (CGPRPSL_AWD_TYP_CD)
/

ALTER TABLE CG_PRPSL_T
    ADD CONSTRAINT CG_PRPSL_TR3
    FOREIGN KEY (CG_AGENCY_NBR)
    REFERENCES CG_AGENCY_T (CG_AGENCY_NBR)
/

ALTER TABLE CG_PRPSL_T
    ADD CONSTRAINT CG_PRPSL_TR4
    FOREIGN KEY (CGPRPSL_STAT_CD)
    REFERENCES CG_PRPSL_STAT_T (CGPRPSL_STAT_CD)
/

ALTER TABLE CG_PRPSL_T
    ADD CONSTRAINT CG_PRPSL_TR5
    FOREIGN KEY (CG_FEDPT_AGNCY_NBR)
    REFERENCES CG_AGENCY_T (CG_AGENCY_NBR)
/

ALTER TABLE CG_PRPSL_T
    ADD CONSTRAINT CG_PRPSL_TR6
    FOREIGN KEY (CGPRPSL_PURPOSE_CD)
    REFERENCES CG_PRPSL_PURPOSE_T (CGPRPSL_PURPOSE_CD)
/

ALTER TABLE CG_PRPSL_T
    ADD CONSTRAINT CG_PRPSL_TR7
    FOREIGN KEY (CG_CFDA_NBR)
    REFERENCES CA_CFDA_REF_T (CG_CFDA_NBR)
/

ALTER TABLE CM_AST_COMPONENT_T
    ADD CONSTRAINT CM_AST_COMPONENT_TR2
    FOREIGN KEY (CACMP_COND_CD)
    REFERENCES CM_AST_CONDITION_T (CPTLAST_COND_CD)
/

ALTER TABLE CM_AST_DEPR_CNVNTN_T
    ADD CONSTRAINT CM_AST_DEPR_CNVNTN_TR1
    FOREIGN KEY (FIN_OBJ_SUB_TYPE_CD)
    REFERENCES CA_OBJ_SUB_TYPE_T (FIN_OBJ_SUB_TYP_CD)
/

ALTER TABLE CM_AST_LOC_DTL_T
    ADD CONSTRAINT CM_AST_LOC_DTL_TR2
    FOREIGN KEY (CAMPUS_CD, BLDG_CD)
    REFERENCES SH_BUILDING_T (CAMPUS_CD, BLDG_CD)
/

ALTER TABLE CM_AST_LOC_DTL_T
    ADD CONSTRAINT CM_AST_LOC_DTL_TR3
    FOREIGN KEY (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
    REFERENCES SH_ROOM_T (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
/

ALTER TABLE CM_AST_LOC_DTL_T
    ADD CONSTRAINT CM_AST_LOC_DTL_TR4
    FOREIGN KEY (FDOC_NBR)
    REFERENCES CM_AST_LOC_DOC_T (FDOC_NBR)
/

ALTER TABLE CM_AST_LOC_T
    ADD CONSTRAINT CM_AST_LOC_TR2
    FOREIGN KEY (AST_LOC_TYP_CD)
    REFERENCES CM_AST_LOC_TYP_T (CPTLAST_LOC_TYP_CD)
/

ALTER TABLE CM_AST_PAYMENT_T
    ADD CONSTRAINT CM_AST_PAYMENT_TR11
    FOREIGN KEY (FS_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE CM_AST_PAYMENT_T
    ADD CONSTRAINT CM_AST_PAYMENT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CM_AST_PAYMENT_T
    ADD CONSTRAINT CM_AST_PAYMENT_TR5
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CM_AST_PMT_AST_DTL_T
    ADD CONSTRAINT CM_AST_PMT_AST_DTL_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES CM_AST_PMT_DOC_T (FDOC_NBR)
/

ALTER TABLE CM_AST_PMT_DOC_T
    ADD CONSTRAINT CM_AST_PMT_DOC_TR1
    FOREIGN KEY (AST_PMT_DST_CD)
    REFERENCES CM_AST_PMT_DST_CD_T (AST_PMT_DST_CD)
/

ALTER TABLE CM_AST_PMT_DTL_T
    ADD CONSTRAINT CM_AST_PMT_DTL_TR1
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE CM_AST_PMT_DTL_T
    ADD CONSTRAINT CM_AST_PMT_DTL_TR10
    FOREIGN KEY (EXPND_FS_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE CM_AST_PMT_DTL_T
    ADD CONSTRAINT CM_AST_PMT_DTL_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CM_AST_PMT_DTL_T
    ADD CONSTRAINT CM_AST_PMT_DTL_TR5
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CM_AST_RETIRE_DOC_T
    ADD CONSTRAINT CM_AST_RETIRE_DOC_TR2
    FOREIGN KEY (MERGED_TGT_CPTLAST_NBR)
    REFERENCES CM_CPTLAST_T (CPTLAST_NBR)
/

ALTER TABLE CM_AST_RETIRE_DOC_T
    ADD CONSTRAINT CM_AST_RETIRE_DOC_TR3
    FOREIGN KEY (AST_RETIRE_REAS_CD)
    REFERENCES CM_RETIRE_REAS_T (AST_RETIRE_REAS_CD)
/

ALTER TABLE CM_AST_RETIRE_DOC_T
    ADD CONSTRAINT CM_AST_RETIRE_DOC_TR4
    FOREIGN KEY (AST_RETIR_COA_CD, AST_RETIR_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CM_AST_RETIRE_DOC_T
    ADD CONSTRAINT CM_AST_RETIRE_DOC_TR5
    FOREIGN KEY (AST_RETIR_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CM_AST_RETIRE_DTL_T
    ADD CONSTRAINT CM_AST_RETIRE_DTL_TR2
    FOREIGN KEY (CPTLAST_NBR)
    REFERENCES CM_CPTLAST_T (CPTLAST_NBR)
/

ALTER TABLE CM_AST_TRNFR_DOC_T
    ADD CONSTRAINT CM_AST_TRNFR_DOC_TR10
    FOREIGN KEY (CPTLAST_NBR)
    REFERENCES CM_CPTLAST_T (CPTLAST_NBR)
/

ALTER TABLE CM_AST_TRNFR_DOC_T
    ADD CONSTRAINT CM_AST_TRNFR_DOC_TR3
    FOREIGN KEY (ORG_OWNER_COA_CD, ORG_OWNER_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CM_AST_TRNFR_DOC_T
    ADD CONSTRAINT CM_AST_TRNFR_DOC_TR4
    FOREIGN KEY (ORG_OWNER_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CM_AST_TRNFR_DOC_T
    ADD CONSTRAINT CM_AST_TRNFR_DOC_TR8
    FOREIGN KEY (CAMPUS_CD, BLDG_CD)
    REFERENCES SH_BUILDING_T (CAMPUS_CD, BLDG_CD)
/

ALTER TABLE CM_AST_TRNFR_DOC_T
    ADD CONSTRAINT CM_AST_TRNFR_DOC_TR9
    FOREIGN KEY (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
    REFERENCES SH_ROOM_T (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
/

ALTER TABLE CM_CPTLAST_DOC_T
    ADD CONSTRAINT CM_CPTLAST_DOC_TR2
    FOREIGN KEY (CPTLAST_TYP_CD)
    REFERENCES CM_ASSET_TYPE_T (CPTLAST_TYP_CD)
/

ALTER TABLE CM_CPTLAST_DOC_T
    ADD CONSTRAINT CM_CPTLAST_DOC_TR3
    FOREIGN KEY (CPTLAST_COND_CD)
    REFERENCES CM_AST_CONDITION_T (CPTLAST_COND_CD)
/

ALTER TABLE CM_CPTLAST_DOC_T
    ADD CONSTRAINT CM_CPTLAST_DOC_TR4
    FOREIGN KEY (AST_INVN_STAT_CD)
    REFERENCES CM_AST_STATUS_T (AST_INVN_STAT_CD)
/

ALTER TABLE CM_CPTLAST_DOC_T
    ADD CONSTRAINT CM_CPTLAST_DOC_TR5
    FOREIGN KEY (ORG_OWNER_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CM_CPTLAST_DOC_T
    ADD CONSTRAINT CM_CPTLAST_DOC_TR6
    FOREIGN KEY (ORG_OWNER_COA_CD, ORG_OWNER_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CM_CPTLAST_DOC_T
    ADD CONSTRAINT CM_CPTLAST_DOC_TR7
    FOREIGN KEY (SEP_SRC_CPTLAST_NBR)
    REFERENCES CM_CPTLAST_T (CPTLAST_NBR)
/

ALTER TABLE CM_CPTLAST_DTL_T
    ADD CONSTRAINT CM_CPTLAST_DTL_TR2
    FOREIGN KEY (CAMPUS_CD, BLDG_CD)
    REFERENCES SH_BUILDING_T (CAMPUS_CD, BLDG_CD)
/

ALTER TABLE CM_CPTLAST_DTL_T
    ADD CONSTRAINT CM_CPTLAST_DTL_TR3
    FOREIGN KEY (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
    REFERENCES SH_ROOM_T (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
/

ALTER TABLE CM_CPTLAST_DTL_T
    ADD CONSTRAINT CM_CPTLAST_DTL_TR7
    FOREIGN KEY (CPTLAST_TYP_CD)
    REFERENCES CM_ASSET_TYPE_T (CPTLAST_TYP_CD)
/

ALTER TABLE CM_CPTLAST_OBJ_T
    ADD CONSTRAINT CM_CPTLAST_OBJ_TR4
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CM_CPTLAST_OBJ_T
    ADD CONSTRAINT CM_CPTLAST_OBJ_TR5
    FOREIGN KEY (FIN_OBJ_SUB_TYPE_CD)
    REFERENCES CA_OBJ_SUB_TYPE_T (FIN_OBJ_SUB_TYP_CD)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR1
    FOREIGN KEY (CPTLAST_TYP_CD)
    REFERENCES CM_ASSET_TYPE_T (CPTLAST_TYP_CD)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR12
    FOREIGN KEY (CAMPUS_CD, BLDG_CD)
    REFERENCES SH_BUILDING_T (CAMPUS_CD, BLDG_CD)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR14
    FOREIGN KEY (AST_RETIRE_REAS_CD)
    REFERENCES CM_RETIRE_REAS_T (AST_RETIRE_REAS_CD)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR17
    FOREIGN KEY (CPTLAST_COND_CD)
    REFERENCES CM_AST_CONDITION_T (CPTLAST_COND_CD)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR18
    FOREIGN KEY (AST_INVN_STAT_CD)
    REFERENCES CM_AST_STATUS_T (AST_INVN_STAT_CD)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR2
    FOREIGN KEY (ORG_OWNER_COA_CD, ORG_OWNER_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR21
    FOREIGN KEY (FIN_OBJ_SUB_TYP_CD)
    REFERENCES CA_OBJ_SUB_TYPE_T (FIN_OBJ_SUB_TYP_CD)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR3
    FOREIGN KEY (ORG_OWNER_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR5
    FOREIGN KEY (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
    REFERENCES SH_ROOM_T (CAMPUS_CD, BLDG_CD, BLDG_ROOM_NBR)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR6
    FOREIGN KEY (AST_RETIR_COA_CD, AST_RETIR_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE CM_CPTLAST_T
    ADD CONSTRAINT CM_CPTLAST_TR7
    FOREIGN KEY (AST_RETIR_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE CM_EQPLNRTRN_DOC_T
    ADD CONSTRAINT CM_EQPLNRTRN_DOC_TR9
    FOREIGN KEY (CPTLAST_NBR)
    REFERENCES CM_CPTLAST_T (CPTLAST_NBR)
/

ALTER TABLE CM_INVN_ERR_DTL_T
    ADD CONSTRAINT CM_INVN_ERR_DTL_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES CM_INVN_ERR_DOC_T (FDOC_NBR)
/

ALTER TABLE ER_RSRCH_RSK_TYP_T
    ADD CONSTRAINT ER_RSRCH_RSK_TYP_TR1
    FOREIGN KEY (CTRL_ATTRIB_TYP_CD)
    REFERENCES ER_CTRL_ATTRIB_TYP_T (CTRL_ATTRIB_TYP_CD)
/

ALTER TABLE FP_ACCT_LINES_T
    ADD CONSTRAINT FP_ACCT_LINES_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_ACCT_LINES_T
    ADD CONSTRAINT FP_ACCT_LINES_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE FP_ACCT_LINES_T
    ADD CONSTRAINT FP_ACCT_LINES_TR3
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE FP_ACCT_LINES_T
    ADD CONSTRAINT FP_ACCT_LINES_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE FP_ACCT_LINES_T
    ADD CONSTRAINT FP_ACCT_LINES_TR5
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
    REFERENCES CA_SUB_OBJECT_CD_T (UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
/

ALTER TABLE FP_ACCT_LINES_T
    ADD CONSTRAINT FP_ACCT_LINES_TR6
    FOREIGN KEY (PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE FP_ACCT_LINES_T
    ADD CONSTRAINT FP_ACCT_LINES_TR7
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FP_ACCT_LINES_T
    ADD CONSTRAINT FP_ACCT_LINES_TR9
    FOREIGN KEY (FS_REF_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE FP_ADV_DPST_DTL_T
    ADD CONSTRAINT FP_ADV_DPST_DTL_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_CASH_RCPT_DOC_T (FDOC_NBR)
/

ALTER TABLE FP_ADV_DPST_DTL_T
    ADD CONSTRAINT FP_ADV_DPST_DTL_TR2
    FOREIGN KEY (FDOC_BANK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE FP_BDGT_ADJ_DTL_T
    ADD CONSTRAINT FP_BDGT_ADJ_DTL_TR1
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE FP_BDGT_ADJ_DTL_T
    ADD CONSTRAINT FP_BDGT_ADJ_DTL_TR2
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE FP_BDGT_ADJ_DTL_T
    ADD CONSTRAINT FP_BDGT_ADJ_DTL_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_BDGT_ADJ_DTL_T
    ADD CONSTRAINT FP_BDGT_ADJ_DTL_TR4
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
    REFERENCES CA_SUB_OBJECT_CD_T (UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
/

ALTER TABLE FP_BDGT_ADJ_DTL_T
    ADD CONSTRAINT FP_BDGT_ADJ_DTL_TR5
    FOREIGN KEY (PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE FP_BDGT_ADJ_DTL_T
    ADD CONSTRAINT FP_BDGT_ADJ_DTL_TR6
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE FP_BDGT_ADJ_DTL_T
    ADD CONSTRAINT FP_BDGT_ADJ_DTL_TR7
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_BDGT_ADJ_DOC_T (FDOC_NBR)
/

ALTER TABLE FP_CASH_RCPT_DOC_T
    ADD CONSTRAINT FP_CASH_RCPT_DOC_TR2
    FOREIGN KEY (FDOC_POST_YR, FDOC_POST_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE FP_CPTL_AST_INFO_DTL_T
    ADD CONSTRAINT FP_CPTL_AST_INFO_DTL_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_CPTL_AST_INFO_T (FDOC_NBR)
/

ALTER TABLE FP_CR_CARD_DTL_T
    ADD CONSTRAINT FP_CR_CARD_DTL_TR1
    FOREIGN KEY (FDOC_CCRD_TYP_CD)
    REFERENCES FP_CR_CARD_TYP_T (FDOC_CCRD_TYP_CD)
/

ALTER TABLE FP_CR_CARD_DTL_T
    ADD CONSTRAINT FP_CR_CARD_DTL_TR2
    FOREIGN KEY (FDOC_CCRD_VNDR_NBR)
    REFERENCES FP_CR_CARD_VNDR_T (FDOC_CCRD_VNDR_NBR)
/

ALTER TABLE FP_CR_CARD_DTL_T
    ADD CONSTRAINT FP_CR_CARD_DTL_TR3
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_CASH_RCPT_DOC_T (FDOC_NBR)
/

ALTER TABLE FP_CR_CARD_VNDR_T
    ADD CONSTRAINT FP_CR_CARD_VNDR_TR1
    FOREIGN KEY (INC_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_CR_CARD_VNDR_T
    ADD CONSTRAINT FP_CR_CARD_VNDR_TR3
    FOREIGN KEY (INC_FIN_COA_CD, INC_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE FP_CR_CARD_VNDR_T
    ADD CONSTRAINT FP_CR_CARD_VNDR_TR4
    FOREIGN KEY (EXP_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_CR_CARD_VNDR_T
    ADD CONSTRAINT FP_CR_CARD_VNDR_TR6
    FOREIGN KEY (EXP_FIN_COA_CD, EXP_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE FP_CR_CARD_VNDR_T
    ADD CONSTRAINT FP_CR_CARD_VNDR_TR7
    FOREIGN KEY (FDOC_CCRD_TYP_CD)
    REFERENCES FP_CR_CARD_TYP_T (FDOC_CCRD_TYP_CD)
/

ALTER TABLE FP_CR_CARD_VNDR_T
    ADD CONSTRAINT FP_CR_CARD_VNDR_TR8
    FOREIGN KEY (INC_FIN_COA_CD, INC_ACCT_NBR, INC_SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE FP_CR_CARD_VNDR_T
    ADD CONSTRAINT FP_CR_CARD_VNDR_TR9
    FOREIGN KEY (EXP_FIN_COA_CD, EXP_ACCT_NBR, EXP_SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE FP_CUST_CC_INFO_T
    ADD CONSTRAINT FP_CUST_CC_INFO_TR1
    FOREIGN KEY (FIDOC_CCRD_VNDR_NBR)
    REFERENCES FP_CR_CARD_VNDR_T (FDOC_CCRD_VNDR_NBR)
/

ALTER TABLE FP_DEPOSIT_DOC_T
    ADD CONSTRAINT FP_DEPOSIT_DOC_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_DEPOSIT_HDR_T (FDOC_NBR)
/

ALTER TABLE FP_DEP_CSH_RCPT_T
    ADD CONSTRAINT FP_DEP_CSH_RCPT_TR1
    FOREIGN KEY (FDOC_DPST_NBR, FDOC_LINE_NBR)
    REFERENCES FP_DEPOSIT_DOC_T (FDOC_NBR, FDOC_LINE_NBR)
/

ALTER TABLE FP_DEP_CSH_RCPT_T
    ADD CONSTRAINT FP_DEP_CSH_RCPT_TR2
    FOREIGN KEY (FDOC_CSH_RCPT_NBR)
    REFERENCES FP_CASH_RCPT_DOC_T (FDOC_NBR)
/

ALTER TABLE FP_DV_DOC_T
    ADD CONSTRAINT DV_PMT_MTHD_ID_FK
    FOREIGN KEY (DV_PMT_MTHD_ID)
    REFERENCES OLE_PMT_MTHD_T (OLE_PMT_MTHD_ID)
/

ALTER TABLE FP_DV_DOC_T
    ADD CONSTRAINT FP_DV_DOC_TR2
    FOREIGN KEY (DV_DOC_LOC_CD)
    REFERENCES FP_DV_DOC_LOC_T (DV_DOC_LOC_CD)
/

ALTER TABLE FP_DV_NONEMP_EXP_T
    ADD CONSTRAINT FP_DV_NONEMP_EXP_TR1
    FOREIGN KEY (DV_EXP_CD)
    REFERENCES FP_DV_EXP_TYP_T (DV_EXP_CD)
/

ALTER TABLE FP_DV_NONEMP_EXP_T
    ADD CONSTRAINT FP_DV_NONEMP_EXP_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_DV_NONEM_TRVL_T (FDOC_NBR)
/

ALTER TABLE FP_DV_NONEMP_EXP_T
    ADD CONSTRAINT FP_DV_NONEMP_EXP_TR3
    FOREIGN KEY (DV_EXP_CD, DV_EXP_CO_NM)
    REFERENCES FP_DV_TRVL_CO_NM_T (DV_EXP_CD, DV_EXP_CO_NM)
/

ALTER TABLE FP_DV_NRA_TAX_T
    ADD CONSTRAINT FP_DV_NRA_TAX_TR1
    FOREIGN KEY (INC_CLS_CD)
    REFERENCES FP_INC_CLS_T (INC_CLS_CD)
/

ALTER TABLE FP_DV_PAYEE_DTL_T
    ADD CONSTRAINT FP_DV_PAYEE_DTL_TR1
    FOREIGN KEY (DV_PMT_REAS_CD)
    REFERENCES FP_DV_PMT_REAS_T (DV_PMT_REAS_CD)
/

ALTER TABLE FP_DV_PRECNF_REG_T
    ADD CONSTRAINT FP_DV_PRECNF_REG_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_DV_PRE_CONF_T (FDOC_NBR)
/

ALTER TABLE FP_DV_TRVL_CO_NM_T
    ADD CONSTRAINT FP_DV_TRVL_CO_NM_TR1
    FOREIGN KEY (DV_EXP_CD)
    REFERENCES FP_DV_EXP_TYP_T (DV_EXP_CD)
/

ALTER TABLE FP_DV_WIRE_CHRG_T
    ADD CONSTRAINT FP_DV_WIRE_CHRG_TR1
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE FP_DV_WIRE_CHRG_T
    ADD CONSTRAINT FP_DV_WIRE_CHRG_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_DV_WIRE_CHRG_T
    ADD CONSTRAINT FP_DV_WIRE_CHRG_TR3
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, INC_FIN_OBJ_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE FP_DV_WIRE_CHRG_T
    ADD CONSTRAINT FP_DV_WIRE_CHRG_TR4
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, EXP_FIN_OBJ_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE FP_ERROR_COR_DOC_T
    ADD CONSTRAINT FP_ERROR_COR_DOC_TR2
    FOREIGN KEY (FDOC_POST_YR, FDOC_POST_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE FP_FND_TRNFR_DOC_T
    ADD CONSTRAINT FP_FND_TRNFR_DOC_TR2
    FOREIGN KEY (FDOC_POST_YR, FDOC_POST_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE FP_FSCL_YR_CTRL_T
    ADD CONSTRAINT FP_FSCL_YR_CTRL_TR1
    FOREIGN KEY (FS_FUNC_CTRL_CD)
    REFERENCES FP_FUNC_CTRL_CD_T (FS_FUNC_CTRL_CD)
/

ALTER TABLE FP_FSCL_YR_CTRL_T
    ADD CONSTRAINT FP_FSCL_YR_CTRL_TR2
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE FP_INT_BILL_ITM_T
    ADD CONSTRAINT FP_INT_BILL_ITM_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_INT_BILL_DOC_T (FDOC_NBR)
/

ALTER TABLE FP_JRNL_VCHR_DOC_T
    ADD CONSTRAINT FP_JRNL_VCHR_DOC_TR2
    FOREIGN KEY (FDOC_POST_YR, FDOC_POST_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE FP_JRNL_VCHR_DOC_T
    ADD CONSTRAINT FP_JRNL_VCHR_DOC_TR3
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FP_MOTD_T
    ADD CONSTRAINT FP_MOTD_TR1
    FOREIGN KEY (FS_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE FP_NRA_TAX_PCT_T
    ADD CONSTRAINT FP_NRA_TAX_PCT_TR1
    FOREIGN KEY (INC_CLS_CD)
    REFERENCES FP_INC_CLS_T (INC_CLS_CD)
/

ALTER TABLE FP_OFST_ACCT_T
    ADD CONSTRAINT FP_OFST_ACCT_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_OFST_ACCT_T
    ADD CONSTRAINT FP_OFST_ACCT_TR4
    FOREIGN KEY (FIN_OFST_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_PRCRMNT_ACCT_LINES_T
    ADD CONSTRAINT FP_PRCRMNT_ACCT_LINES_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_PRCRMNT_ACCT_LINES_T
    ADD CONSTRAINT FP_PRCRMNT_ACCT_LINES_TR3
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE FP_PRCRMNT_ACCT_LINES_T
    ADD CONSTRAINT FP_PRCRMNT_ACCT_LINES_TR5
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
    REFERENCES CA_SUB_OBJECT_CD_T (UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
/

ALTER TABLE FP_PRCRMNT_ACCT_LINES_T
    ADD CONSTRAINT FP_PRCRMNT_ACCT_LINES_TR7
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FP_PRCRMNT_ACCT_LINES_T
    ADD CONSTRAINT FP_PRCRMNT_ACCT_LINES_TR8
    FOREIGN KEY (FDOC_NBR, FDOC_TRN_LN_NBR)
    REFERENCES FP_PRCRMNT_TRN_DTL_T (FDOC_NBR, FDOC_TRN_LN_NBR)
/

ALTER TABLE FP_PRCRMNT_CARD_DFLT_T
    ADD CONSTRAINT FP_PRCRMNT_CARD_DFLT_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_PRCRMNT_CARD_DFLT_T
    ADD CONSTRAINT FP_PRCRMNT_CARD_DFLT_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE FP_PRCRMNT_CARD_DFLT_T
    ADD CONSTRAINT FP_PRCRMNT_CARD_DFLT_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE FP_PRCRMNT_CARD_DFLT_T
    ADD CONSTRAINT FP_PRCRMNT_CARD_DFLT_TR4
    FOREIGN KEY (PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE FP_PRCRMNT_DOC_T
    ADD CONSTRAINT FP_PRCRMNT_DOC_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_PRCRMNT_CARD_HLDR_T (FDOC_NBR)
/

ALTER TABLE FP_PRCRMNT_TRN_DTL_T
    ADD CONSTRAINT FP_PRCRMNT_TRN_DTL_TR1
    FOREIGN KEY (FDOC_NBR, FDOC_TRN_LN_NBR)
    REFERENCES FP_PRCRMNT_VNDR_T (FDOC_NBR, FDOC_TRN_LN_NBR)
/

ALTER TABLE FP_PRCRMNT_TRN_DTL_T
    ADD CONSTRAINT FP_PRCRMNT_TRN_DTL_TR2
    FOREIGN KEY (FDOC_NBR)
    REFERENCES FP_PRCRMNT_DOC_T (FDOC_NBR)
/

ALTER TABLE FP_RPT_CD_T
    ADD CONSTRAINT FP_RPT_CD_TR1
    FOREIGN KEY (FIN_RPT_CHRT_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FP_RPT_CD_T
    ADD CONSTRAINT FP_RPT_CD_TR4
    FOREIGN KEY (FIN_RPT_CHRT_CD, FIN_RPT_ORG_CD, FIN_RPTS_TO_RPT_CD)
    REFERENCES FP_RPT_CD_T (FIN_RPT_CHRT_CD, FIN_RPT_ORG_CD, FIN_RPT_CD)
/

ALTER TABLE FP_SALES_TAX_T
    ADD CONSTRAINT FP_SALES_TAX_TR1
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE FP_SALES_TAX_T
    ADD CONSTRAINT FP_SALES_TAX_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FS_HOME_ORIGIN_T
    ADD CONSTRAINT FS_HOME_ORIGIN_TR1
    FOREIGN KEY (FS_HOME_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR1
    FOREIGN KEY (UNIV_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR10
    FOREIGN KEY (FOBJTP_CSH_NINC_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR11
    FOREIGN KEY (ACT_FIN_BAL_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR12
    FOREIGN KEY (BDGT_CHK_BALTYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR13
    FOREIGN KEY (EXT_ENC_FBALTYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR14
    FOREIGN KEY (INT_ENC_FBALTYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR15
    FOREIGN KEY (PRE_ENC_FBALTYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR16
    FOREIGN KEY (ELIM_FINBAL_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR17
    FOREIGN KEY (CSTSHR_ENCUM_FIN_BAL_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR18
    FOREIGN KEY (FIN_OBJECT_TYP_TRNFR_INC_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR19
    FOREIGN KEY (FIN_OBJECT_TYP_TRNFR_EXP_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR2
    FOREIGN KEY (FOBJTP_INC_CSH_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR20
    FOREIGN KEY (BASE_BDGT_FIN_BAL_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR21
    FOREIGN KEY (MO_BDGT_FIN_BAL_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR22
    FOREIGN KEY (NMNL_FIN_BAL_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR3
    FOREIGN KEY (FOBJTP_XPND_EXP_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR4
    FOREIGN KEY (FOBJTP_XPNDNEXP_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR5
    FOREIGN KEY (FOBJTP_EXPNXPND_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR6
    FOREIGN KEY (FOBJ_TYP_ASSET_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR7
    FOREIGN KEY (FOBJ_TYP_LBLTY_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR8
    FOREIGN KEY (FOBJ_TYP_FNDBAL_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_OPTION_T
    ADD CONSTRAINT FS_OPTION_TR9
    FOREIGN KEY (FOBJTP_INC_NCSH_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE FS_TAX_REGION_RATE_T
    ADD CONSTRAINT FS_TAX_REGION_RATE_TR1
    FOREIGN KEY (TAX_REGION_CD)
    REFERENCES FS_TAX_REGION_T (TAX_REGION_CD)
/

ALTER TABLE FS_TAX_REGION_T
    ADD CONSTRAINT FS_TAX_REGION_TR1
    FOREIGN KEY (TAX_REGION_TYP_CD)
    REFERENCES FS_TAX_REGION_TYPE_T (TAX_REGION_TYP_CD)
/

ALTER TABLE FS_TAX_REGION_T
    ADD CONSTRAINT FS_TAX_REGION_TR2
    FOREIGN KEY (LIAB_ACCT_FIN_COA_CD, LIAB_ACCT_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE FS_TAX_REGION_T
    ADD CONSTRAINT FS_TAX_REGION_TR3
    FOREIGN KEY (LIAB_ACCT_FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ACCT_BALANCES_HIST_T
    ADD CONSTRAINT GL_ACCT_BALANCES_HIST_TR1
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_ACCT_BALANCES_HIST_T
    ADD CONSTRAINT GL_ACCT_BALANCES_HIST_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ACCT_BALANCES_HIST_T
    ADD CONSTRAINT GL_ACCT_BALANCES_HIST_TR4
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_ACCT_BALANCES_T
    ADD CONSTRAINT GL_ACCT_BALANCES_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ACCT_BALANCES_T
    ADD CONSTRAINT GL_ACCT_BALANCES_TR3
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_ACCT_BALANCES_T
    ADD CONSTRAINT GL_ACCT_BALANCES_TR6
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_BALANCE_HIST_T
    ADD CONSTRAINT GL_BALANCE_HIST_TR1
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_BALANCE_HIST_T
    ADD CONSTRAINT GL_BALANCE_HIST_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_BALANCE_HIST_T
    ADD CONSTRAINT GL_BALANCE_HIST_TR4
    FOREIGN KEY (FIN_OBJ_TYP_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE GL_BALANCE_HIST_T
    ADD CONSTRAINT GL_BALANCE_HIST_TR5
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE GL_BALANCE_HIST_T
    ADD CONSTRAINT GL_BALANCE_HIST_TR6
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_BALANCE_T
    ADD CONSTRAINT GL_BALANCE_TR1
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_BALANCE_T
    ADD CONSTRAINT GL_BALANCE_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_BALANCE_T
    ADD CONSTRAINT GL_BALANCE_TR4
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_BALANCE_T
    ADD CONSTRAINT GL_BALANCE_TR6
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE GL_BALANCE_T
    ADD CONSTRAINT GL_BALANCE_TR7
    FOREIGN KEY (FIN_OBJ_TYP_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE GL_COR_CHG_GRP_T
    ADD CONSTRAINT GL_COR_CHG_GRP_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES GL_COR_DOC_T (FDOC_NBR)
/

ALTER TABLE GL_COR_CHG_T
    ADD CONSTRAINT GL_COR_CHG_TR1
    FOREIGN KEY (FDOC_NBR, GL_COR_CHG_GRP_LN_NBR)
    REFERENCES GL_COR_CHG_GRP_T (FDOC_NBR, GL_COR_CHG_GRP_LN_NBR)
/

ALTER TABLE GL_COR_CRTA_T
    ADD CONSTRAINT GL_COR_CRTA_TR1
    FOREIGN KEY (FDOC_NBR, GL_COR_CHG_GRP_LN_NBR)
    REFERENCES GL_COR_CHG_GRP_T (FDOC_NBR, GL_COR_CHG_GRP_LN_NBR)
/

ALTER TABLE GL_ENCUMBRANCE_HIST_T
    ADD CONSTRAINT GL_ENCUMBRANCE_HIST_TR1
    FOREIGN KEY (FS_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE GL_ENCUMBRANCE_HIST_T
    ADD CONSTRAINT GL_ENCUMBRANCE_HIST_TR3
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE GL_ENCUMBRANCE_HIST_T
    ADD CONSTRAINT GL_ENCUMBRANCE_HIST_TR4
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_ENCUMBRANCE_HIST_T
    ADD CONSTRAINT GL_ENCUMBRANCE_HIST_TR5
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ENCUMBRANCE_HIST_T
    ADD CONSTRAINT GL_ENCUMBRANCE_HIST_TR6
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_ENCUMBRANCE_T
    ADD CONSTRAINT GL_ENCUMBRANCE_TR1
    FOREIGN KEY (FS_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE GL_ENCUMBRANCE_T
    ADD CONSTRAINT GL_ENCUMBRANCE_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ENCUMBRANCE_T
    ADD CONSTRAINT GL_ENCUMBRANCE_TR4
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_ENCUMBRANCE_T
    ADD CONSTRAINT GL_ENCUMBRANCE_TR5
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE GL_ENCUMBRANCE_T
    ADD CONSTRAINT GL_ENCUMBRANCE_TR6
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_ENTRY_HIST_T
    ADD CONSTRAINT GL_ENTRY_HIST_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ENTRY_HIST_T
    ADD CONSTRAINT GL_ENTRY_HIST_TR2
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_ENTRY_HIST_T
    ADD CONSTRAINT GL_ENTRY_HIST_TR3
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_ENTRY_HIST_T
    ADD CONSTRAINT GL_ENTRY_HIST_TR4
    FOREIGN KEY (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE GL_ENTRY_HIST_T
    ADD CONSTRAINT GL_ENTRY_HIST_TR5
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE GL_ENTRY_T
    ADD CONSTRAINT GL_ENTRY_TR11
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_ENTRY_T
    ADD CONSTRAINT GL_ENTRY_TR12
    FOREIGN KEY (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE GL_ENTRY_T
    ADD CONSTRAINT GL_ENTRY_TR13
    FOREIGN KEY (FDOC_REVERSAL_DT)
    REFERENCES SH_UNIV_DATE_T (UNIV_DT)
/

ALTER TABLE GL_ENTRY_T
    ADD CONSTRAINT GL_ENTRY_TR14
    FOREIGN KEY (FS_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE GL_ENTRY_T
    ADD CONSTRAINT GL_ENTRY_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ENTRY_T
    ADD CONSTRAINT GL_ENTRY_TR3
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_ENTRY_T
    ADD CONSTRAINT GL_ENTRY_TR5
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE GL_ENTRY_T
    ADD CONSTRAINT GL_ENTRY_TR7
    FOREIGN KEY (FIN_OBJ_TYP_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE GL_EXPEND_TRN_MT
    ADD CONSTRAINT GL_EXPEND_TRN_TR1
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE GL_ID_BILL_T
    ADD CONSTRAINT GL_ID_BILL_TR1
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_ID_BILL_T
    ADD CONSTRAINT GL_ID_BILL_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE GL_ID_BILL_T
    ADD CONSTRAINT GL_ID_BILL_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ID_BILL_T
    ADD CONSTRAINT GL_ID_BILL_TR4
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE GL_ID_BILL_T
    ADD CONSTRAINT GL_ID_BILL_TR5
    FOREIGN KEY (FIN_OBJ_TYP_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE GL_OFFSET_DEFN_T
    ADD CONSTRAINT GL_OFFSET_DEFN_TR1
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_OFFSET_DEFN_T
    ADD CONSTRAINT GL_OFFSET_DEFN_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_OFFSET_DEFN_T
    ADD CONSTRAINT GL_OFFSET_DEFN_TR3
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_OFFSET_DEFN_T
    ADD CONSTRAINT GL_OFFSET_DEFN_TR4
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE GL_ORG_RVRSN_CTGRY_AMT_T
    ADD CONSTRAINT GL_ORG_RVRSN_CTGRY_AMT_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ORG_RVRSN_CTGRY_AMT_T
    ADD CONSTRAINT GL_ORG_RVRSN_CTGRY_AMT_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE GL_ORG_RVRSN_CTGRY_AMT_T
    ADD CONSTRAINT GL_ORG_RVRSN_CTGRY_AMT_TR4
    FOREIGN KEY (ORG_RVRSN_CTGRY_CD)
    REFERENCES CA_ORG_RVRSN_CTGRY_T (ORG_RVRSN_CTGRY_CD)
/

ALTER TABLE GL_ORG_RVRSN_CTGRY_AMT_T
    ADD CONSTRAINT GL_ORG_RVRSN_CTGRY_AMT_TR5
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES GL_ORG_RVRSN_UNIT_WRK_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE GL_ORG_RVRSN_UNIT_WRK_T
    ADD CONSTRAINT GL_ORG_RVRSN_UNIT_WRK_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_ORG_RVRSN_UNIT_WRK_T
    ADD CONSTRAINT GL_ORG_RVRSN_UNIT_WRK_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE GL_REVERSAL_T
    ADD CONSTRAINT GL_REVERSAL_TR10
    FOREIGN KEY (TRANSACTION_DT)
    REFERENCES SH_UNIV_DATE_T (UNIV_DT)
/

ALTER TABLE GL_REVERSAL_T
    ADD CONSTRAINT GL_REVERSAL_TR11
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE GL_REVERSAL_T
    ADD CONSTRAINT GL_REVERSAL_TR12
    FOREIGN KEY (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE GL_REVERSAL_T
    ADD CONSTRAINT GL_REVERSAL_TR13
    FOREIGN KEY (FDOC_REVERSAL_DT)
    REFERENCES SH_UNIV_DATE_T (UNIV_DT)
/

ALTER TABLE GL_REVERSAL_T
    ADD CONSTRAINT GL_REVERSAL_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_REVERSAL_T
    ADD CONSTRAINT GL_REVERSAL_TR3
    FOREIGN KEY (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE GL_REVERSAL_T
    ADD CONSTRAINT GL_REVERSAL_TR5
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE GL_REVERSAL_T
    ADD CONSTRAINT GL_REVERSAL_TR7
    FOREIGN KEY (FIN_OBJ_TYP_CD)
    REFERENCES CA_OBJ_TYPE_T (FIN_OBJ_TYP_CD)
/

ALTER TABLE GL_SF_BALANCES_T
    ADD CONSTRAINT GL_SF_BALANCES_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE GL_SF_BALANCES_T
    ADD CONSTRAINT GL_SF_BALANCES_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE GL_SF_REBUILD_T
    ADD CONSTRAINT GL_SF_REBUILD_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE OLE_CA_ACCT_ENCUM_CNSTRT_T
    ADD CONSTRAINT OLE_CA_ACCT_ENCUM_CNSTRT_TR1
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE OLE_CA_ACCT_ENCUM_CNSTRT_T
    ADD CONSTRAINT OLE_CA_ACCT_ENCUM_CNSTRT_TR3
    FOREIGN KEY (OLE_CNSTRT_TYP_ID)
    REFERENCES OLE_CNSTRT_TYP_T (OLE_CNSTRT_TYP_ID)
/

ALTER TABLE OLE_CA_ACCT_ENCUM_CNSTRT_T
    ADD CONSTRAINT OLE_CA_ACCT_ENCUM_CNSTRT_TR4
    FOREIGN KEY (OLE_SFC_TYP_ID)
    REFERENCES OLE_CA_ACCT_SFC_TYPE_T (OLE_SFC_TYP_ID)
/

ALTER TABLE OLE_CA_ACCT_EXP_CNSTRT_T
    ADD CONSTRAINT OLE_CA_ACCT_EXP_CNSTRT_TR1
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE OLE_CA_ACCT_EXP_CNSTRT_T
    ADD CONSTRAINT OLE_CA_ACCT_EXP_CNSTRT_TR3
    FOREIGN KEY (OLE_CNSTRT_TYP_ID)
    REFERENCES OLE_CNSTRT_TYP_T (OLE_CNSTRT_TYP_ID)
/

ALTER TABLE OLE_CA_ACCT_EXP_CNSTRT_T
    ADD CONSTRAINT OLE_CA_ACCT_EXP_CNSTRT_TR4
    FOREIGN KEY (OLE_SFC_TYP_ID)
    REFERENCES OLE_CA_ACCT_SFC_TYPE_T (OLE_SFC_TYP_ID)
/

ALTER TABLE OLE_CA_ACCT_LGCY_LMS_FND_T
    ADD CONSTRAINT OLE_CA_ACCT_LGCY_LMS_FND_TR1
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE OLE_CA_ACCT_STWD_T
    ADD CONSTRAINT OLE_CA_ACCT_STWD_TR1
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE OLE_CA_ACCT_STWD_T
    ADD CONSTRAINT OLE_CA_ACCT_STWD_TR3
    FOREIGN KEY (OLE_STWD_TYP_ID)
    REFERENCES OLE_CA_ACCT_STWD_TYP_T (OLE_STWD_TYP_ID)
/

ALTER TABLE OLE_DV_FP_ACCT_LINES_T
    ADD CONSTRAINT OLE_DV_FP_ACCT_LINES_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE OLE_DV_FP_ACCT_LINES_T
    ADD CONSTRAINT OLE_DV_FP_ACCT_LINES_TR2
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE OLE_DV_FP_ACCT_LINES_T
    ADD CONSTRAINT OLE_DV_FP_ACCT_LINES_TR3
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, FIN_OBJECT_CD)
    REFERENCES CA_OBJECT_CODE_T (UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD)
/

ALTER TABLE OLE_DV_FP_ACCT_LINES_T
    ADD CONSTRAINT OLE_DV_FP_ACCT_LINES_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE OLE_DV_FP_ACCT_LINES_T
    ADD CONSTRAINT OLE_DV_FP_ACCT_LINES_TR5
    FOREIGN KEY (FDOC_POST_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
    REFERENCES CA_SUB_OBJECT_CD_T (UNIV_FISCAL_YR, FIN_COA_CD, ACCOUNT_NBR, FIN_OBJECT_CD, FIN_SUB_OBJ_CD)
/

ALTER TABLE OLE_DV_FP_ACCT_LINES_T
    ADD CONSTRAINT OLE_DV_FP_ACCT_LINES_TR6
    FOREIGN KEY (PROJECT_CD)
    REFERENCES CA_PROJECT_T (PROJECT_CD)
/

ALTER TABLE OLE_DV_FP_ACCT_LINES_T
    ADD CONSTRAINT OLE_DV_FP_ACCT_LINES_TR7
    FOREIGN KEY (FIN_BALANCE_TYP_CD)
    REFERENCES CA_BALANCE_TYPE_T (FIN_BALANCE_TYP_CD)
/

ALTER TABLE OLE_DV_FP_ACCT_LINES_T
    ADD CONSTRAINT OLE_DV_FP_ACCT_LINES_TR9
    FOREIGN KEY (FS_REF_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE OLE_DV_FP_PAYEE_DTL_T
    ADD CONSTRAINT OLE_DV_FP_PAYEE_DTL_TR1
    FOREIGN KEY (DV_PMT_REAS_CD)
    REFERENCES FP_DV_PMT_REAS_T (DV_PMT_REAS_CD)
/

ALTER TABLE OLE_EXCHANGE_RT_T
    ADD CONSTRAINT OLE_EXCHANGE_RT_TR1
    FOREIGN KEY (OLE_CURR_TYP_ID)
    REFERENCES OLE_CURR_TYP_T (OLE_CURR_TYP_ID)
/

ALTER TABLE OLE_PMT_RQST_ITM_NTE_T
    ADD CONSTRAINT OLE_PMT_RQST_ITM_NTE_TR1
    FOREIGN KEY (PMT_RQST_ITM_ID)
    REFERENCES AP_PMT_RQST_ITM_T (PMT_RQST_ITM_ID)
/

ALTER TABLE OLE_PUR_PO_FAIL_DOC_T
    ADD CONSTRAINT OLE_PUR_PO_FAIL_DOC_TR1
    FOREIGN KEY (PO_LOAD_SUM_ID)
    REFERENCES OLE_PUR_PO_LOAD_SUM_T (PO_LOAD_SUM_ID)
/

ALTER TABLE OLE_PUR_PO_FAIL_DOC_T
    ADD CONSTRAINT OLE_PUR_PO_FAIL_DOC_TR2
    FOREIGN KEY (ERR_ID)
    REFERENCES OLE_PUR_PO_ERR_CDS_T (ERR_ID)
/

ALTER TABLE OLE_PUR_PO_ITM_NTE_T
    ADD CONSTRAINT OLE_PUR_PO_ITM_NTE_TR1
    FOREIGN KEY (FDOC_NBR, PO_ITM_ID)
    REFERENCES PUR_PO_ITM_T (FDOC_NBR, PO_ITM_ID)
/

ALTER TABLE OLE_PUR_PO_ITM_NTE_T
    ADD CONSTRAINT OLE_PUR_PO_ITM_NTE_TR2
    FOREIGN KEY (OLE_NTE_TYP_ID)
    REFERENCES OLE_NTE_TYP_T (OLE_NTE_TYP_ID)
/

ALTER TABLE OLE_PUR_RCVNG_COR_LN_ITM_DOC_T
    ADD CONSTRAINT OLE_RCVNG_COR_LN_ITM_DOC_TR1
    FOREIGN KEY (RCVNG_COR_ITM_ID)
    REFERENCES PUR_RCVNG_COR_ITM_T (RCVNG_COR_ITM_ID)
/

ALTER TABLE OLE_PUR_RCVNG_COR_LN_ITM_EXC_T
    ADD CONSTRAINT OLE_RCVNG_COR_LN_ITM_EXC_TR1
    FOREIGN KEY (RCVNG_LN_ITM_ID)
    REFERENCES PUR_RCVNG_LN_ITM_T (RCVNG_LN_ITM_ID)
/

ALTER TABLE OLE_PUR_RCVNG_COR_LN_ITM_EXC_T
    ADD CONSTRAINT OLE_RCVNG_COR_LN_ITM_EXC_TR2
    FOREIGN KEY (OLE_RCVNG_LN_ITM_EXC_MDOC_ID)
    REFERENCES OLE_PUR_RCVNG_LN_ITM_EXC_MDC_T (OLE_RCVNG_LN_ITM_EXC_MDOC_ID)
/

ALTER TABLE OLE_PUR_RCVNG_COR_LN_ITM_NTE_T
    ADD CONSTRAINT OLE_RCVNG_COR_LN_ITM_NTE_TR1
    FOREIGN KEY (RCVNG_COR_ITM_ID)
    REFERENCES PUR_RCVNG_COR_ITM_T (RCVNG_COR_ITM_ID)
/

ALTER TABLE OLE_PUR_RCVNG_COR_LN_ITM_NTE_T
    ADD CONSTRAINT OLE_RCVNG_COR_LN_ITM_NTE_TR2
    FOREIGN KEY (OLE_NTE_TYP_ID)
    REFERENCES OLE_NTE_TYP_T (OLE_NTE_TYP_ID)
/

ALTER TABLE OLE_PUR_RCVNG_LN_ITM_DOC_T
    ADD CONSTRAINT OLE_PUR_RCVNG_LN_ITM_DOC_TR1
    FOREIGN KEY (RCVNG_LN_ITM_ID)
    REFERENCES PUR_RCVNG_LN_ITM_T (RCVNG_LN_ITM_ID)
/

ALTER TABLE OLE_PUR_RCVNG_LN_ITM_EXC_T
    ADD CONSTRAINT OLE_PUR_RCVNG_LN_ITM_EXC_TR1
    FOREIGN KEY (RCVNG_LN_ITM_ID)
    REFERENCES PUR_RCVNG_LN_ITM_T (RCVNG_LN_ITM_ID)
/

ALTER TABLE OLE_PUR_RCVNG_LN_ITM_EXC_T
    ADD CONSTRAINT OLE_PUR_RCVNG_LN_ITM_EXC_TR2
    FOREIGN KEY (OLE_RCVNG_LN_ITM_EXC_MDOC_ID)
    REFERENCES OLE_PUR_RCVNG_LN_ITM_EXC_MDC_T (OLE_RCVNG_LN_ITM_EXC_MDOC_ID)
/

ALTER TABLE OLE_PUR_RCVNG_LN_ITM_NTE_T
    ADD CONSTRAINT OLE_PUR_RCVNG_LN_ITM_NTE_TR1
    FOREIGN KEY (RCVNG_LN_ITM_ID)
    REFERENCES PUR_RCVNG_LN_ITM_T (RCVNG_LN_ITM_ID)
/

ALTER TABLE OLE_PUR_RCVNG_LN_ITM_NTE_T
    ADD CONSTRAINT OLE_PUR_RCVNG_LN_ITM_NTE_TR2
    FOREIGN KEY (OLE_NTE_TYP_ID)
    REFERENCES OLE_NTE_TYP_T (OLE_NTE_TYP_ID)
/

ALTER TABLE OLE_PUR_REQS_ITM_T_NTE_T
    ADD CONSTRAINT OLE_PUR_REQS_ITM_T_NTE_TR1
    FOREIGN KEY (REQS_ITM_ID)
    REFERENCES PUR_REQS_ITM_T (REQS_ITM_ID)
/

ALTER TABLE OLE_PUR_REQS_ITM_T_NTE_T
    ADD CONSTRAINT OLE_PUR_REQS_ITM_T_NTE_TR2
    FOREIGN KEY (OLE_NTE_TYP_ID)
    REFERENCES OLE_NTE_TYP_T (OLE_NTE_TYP_ID)
/

ALTER TABLE OLE_VNDR_TRANS_FRMT_TYP_INT_T
    ADD CONSTRAINT OLE_VNDR_TRANS_FRMT_I_TR1
    FOREIGN KEY (OLE_VNDR_TRANS_FRMT_ID)
    REFERENCES OLE_VNDR_TRANS_FRMT_T (OLE_VNDR_TRANS_FRMT_ID)
/

ALTER TABLE OLE_VNDR_TRANS_FRMT_TYP_INT_T
    ADD CONSTRAINT OLE_VNDR_TRANS_FRMT_I_TR2
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE OLE_VNDR_TRANS_FRMT_TYP_INT_T
    ADD CONSTRAINT OLE_VNDR_TRANS_FRMT_I_TR3
    FOREIGN KEY (OLE_TRANS_TYP_ID)
    REFERENCES OLE_VNDR_TRANS_TYP_T (OLE_TRANS_TYP_ID)
/

ALTER TABLE PDP_ACH_ACCT_NBR_T
    ADD CONSTRAINT PDP_ACH_ACCT_NBR_TR1
    FOREIGN KEY (PMT_GRP_ID)
    REFERENCES PDP_PMT_GRP_T (PMT_GRP_ID)
/

ALTER TABLE PDP_CUST_BNK_T
    ADD CONSTRAINT PDP_CUST_BNK_TR1
    FOREIGN KEY (CUST_ID)
    REFERENCES PDP_CUST_PRFL_T (CUST_ID)
  ON DELETE CASCADE
/

ALTER TABLE PDP_CUST_BNK_T
    ADD CONSTRAINT PDP_CUST_BNK_TR3
    FOREIGN KEY (DISB_TYP_CD)
    REFERENCES PDP_DISB_TYP_CD_T (DISB_TYP_CD)
/

ALTER TABLE PDP_CUST_BNK_T
    ADD CONSTRAINT PDP_CUST_BNK_T_TR2
    FOREIGN KEY (BNK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE PDP_CUST_PRFL_T
    ADD CONSTRAINT PDP_CUST_PRFL_T_TR3
    FOREIGN KEY (DFLT_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PDP_CUST_PRFL_T
    ADD CONSTRAINT PDP_CUST_PRFL_T_TR4
    FOREIGN KEY (DFLT_COA_CD, DFLT_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE PDP_CUST_PRFL_T
    ADD CONSTRAINT PDP_CUST_PRFL_T_TR6
    FOREIGN KEY (ACH_TRANS_TYP)
    REFERENCES PDP_ACH_TRANS_TYP_T (TRANS_TYP)
/

ALTER TABLE PDP_DISB_NBR_RNG_T
    ADD CONSTRAINT PDP_DISB_NBR_RNG_T_TR2
    FOREIGN KEY (BNK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE PDP_DISB_NBR_RNG_T
    ADD CONSTRAINT PDP_DISB_NBR_RNG_T_TR3
    FOREIGN KEY (DISB_TYP_CD)
    REFERENCES PDP_DISB_TYP_CD_T (DISB_TYP_CD)
/

ALTER TABLE PDP_FIL_T
    ADD CONSTRAINT PDP_FIL_TR1
    FOREIGN KEY (CUST_ID)
    REFERENCES PDP_CUST_PRFL_T (CUST_ID)
/

ALTER TABLE PDP_FMT_PROC_T
    ADD CONSTRAINT PDP_FMT_PROC_TR1
    FOREIGN KEY (PMT_PROC_ID)
    REFERENCES PDP_PROC_T (PROC_ID)
/

ALTER TABLE PDP_PAYEE_ACH_ACCT_T
    ADD CONSTRAINT PDP_PAYEE_ACH_ACCT_T_TR2
    FOREIGN KEY (BNK_ACCT_TYP_CD)
    REFERENCES PDP_ACH_TRANS_CD_T (TRANS_CD)
/

ALTER TABLE PDP_PAYEE_ACH_ACCT_T
    ADD CONSTRAINT PDP_PAYEE_ACH_ACCT_T_TR3
    FOREIGN KEY (PAYEE_ID_TYP_CD)
    REFERENCES PDP_PAYEE_TYP_T (PAYEE_TYP_CD)
/

ALTER TABLE PDP_PAYEE_ACH_ACCT_T
    ADD CONSTRAINT PDP_PAYEE_ACH_ACCT_T_TR4
    FOREIGN KEY (ACH_TRANS_TYP)
    REFERENCES PDP_ACH_TRANS_TYP_T (TRANS_TYP)
/

ALTER TABLE PDP_PMT_ACCT_DTL_T
    ADD CONSTRAINT PDP_PMT_ACCT_DTL_TR1
    FOREIGN KEY (PMT_DTL_ID)
    REFERENCES PDP_PMT_DTL_T (PMT_DTL_ID)
/

ALTER TABLE PDP_PMT_ACCT_HIST_T
    ADD CONSTRAINT PDP_PMT_ACCT_HIST_TR1
    FOREIGN KEY (PMT_ACCT_DTL_ID)
    REFERENCES PDP_PMT_ACCT_DTL_T (PMT_ACCT_DTL_ID)
/

ALTER TABLE PDP_PMT_ACCT_HIST_T
    ADD CONSTRAINT PDP_PMT_ACCT_HIST_TR2
    FOREIGN KEY (ACCTG_CHG_CD)
    REFERENCES PDP_ACCTG_CHG_CD_T (ACCTG_CHG_CD)
/

ALTER TABLE PDP_PMT_DTL_T
    ADD CONSTRAINT PDP_PMT_DTL_TR1
    FOREIGN KEY (PMT_GRP_ID)
    REFERENCES PDP_PMT_GRP_T (PMT_GRP_ID)
/

ALTER TABLE PDP_PMT_DTL_T
    ADD CONSTRAINT PDP_PMT_DTL_T_TR2
    FOREIGN KEY (FS_ORIGIN_CD)
    REFERENCES FS_ORIGIN_CODE_T (FS_ORIGIN_CD)
/

ALTER TABLE PDP_PMT_GRP_HIST_T
    ADD CONSTRAINT PDP_PMT_GRP_HIST_TR1
    FOREIGN KEY (PMT_GRP_ID)
    REFERENCES PDP_PMT_GRP_T (PMT_GRP_ID)
/

ALTER TABLE PDP_PMT_GRP_HIST_T
    ADD CONSTRAINT PDP_PMT_GRP_HIST_TR2
    FOREIGN KEY (ORIG_PROC_ID)
    REFERENCES PDP_PROC_T (PROC_ID)
/

ALTER TABLE PDP_PMT_GRP_HIST_T
    ADD CONSTRAINT PDP_PMT_GRP_HIST_TR3
    FOREIGN KEY (ORIG_PMT_STAT_CD)
    REFERENCES PDP_PMT_STAT_CD_T (PMT_STAT_CD)
/

ALTER TABLE PDP_PMT_GRP_HIST_T
    ADD CONSTRAINT PDP_PMT_GRP_HIST_TR4
    FOREIGN KEY (PMT_CHG_CD)
    REFERENCES PDP_PMT_CHG_CD_T (PMT_CHG_CD)
/

ALTER TABLE PDP_PMT_GRP_HIST_T
    ADD CONSTRAINT PDP_PMT_GRP_HIST_TR6
    FOREIGN KEY (ORIG_DISB_TYP_CD)
    REFERENCES PDP_DISB_TYP_CD_T (DISB_TYP_CD)
/

ALTER TABLE PDP_PMT_GRP_HIST_T
    ADD CONSTRAINT PDP_PMT_GRP_HIST_T_TR5
    FOREIGN KEY (ORIG_BNK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE PDP_PMT_GRP_T
    ADD CONSTRAINT PDP_PMT_GRP_TR1
    FOREIGN KEY (PROC_ID)
    REFERENCES PDP_PROC_T (PROC_ID)
/

ALTER TABLE PDP_PMT_GRP_T
    ADD CONSTRAINT PDP_PMT_GRP_TR2
    FOREIGN KEY (PMT_STAT_CD)
    REFERENCES PDP_PMT_STAT_CD_T (PMT_STAT_CD)
/

ALTER TABLE PDP_PMT_GRP_T
    ADD CONSTRAINT PDP_PMT_GRP_TR3
    FOREIGN KEY (DISB_TYP_CD)
    REFERENCES PDP_DISB_TYP_CD_T (DISB_TYP_CD)
/

ALTER TABLE PDP_PMT_GRP_T
    ADD CONSTRAINT PDP_PMT_GRP_TR5
    FOREIGN KEY (PMT_FIL_ID)
    REFERENCES PDP_FIL_T (PMT_FIL_ID)
/

ALTER TABLE PDP_PMT_GRP_T
    ADD CONSTRAINT PDP_PMT_GRP_T_TR4
    FOREIGN KEY (PAYEE_ID_TYP_CD)
    REFERENCES PDP_PAYEE_TYP_T (PAYEE_TYP_CD)
/

ALTER TABLE PDP_PMT_GRP_T
    ADD CONSTRAINT PDP_PMT_GRP_T_TR7
    FOREIGN KEY (ALTRNT_PAYEE_ID_TYP_CD)
    REFERENCES PDP_PAYEE_TYP_T (PAYEE_TYP_CD)
/

ALTER TABLE PDP_PMT_GRP_T
    ADD CONSTRAINT PDP_PMT_GRP_T_TR8
    FOREIGN KEY (BNK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE PDP_PMT_NTE_TXT_T
    ADD CONSTRAINT PDP_PMT_NTE_TXT_TR1
    FOREIGN KEY (PMT_DTL_ID)
    REFERENCES PDP_PMT_DTL_T (PMT_DTL_ID)
/

ALTER TABLE PDP_PROC_SUM_T
    ADD CONSTRAINT PDP_PROC_SUM_TR1
    FOREIGN KEY (PROC_ID)
    REFERENCES PDP_PROC_T (PROC_ID)
/

ALTER TABLE PDP_PROC_SUM_T
    ADD CONSTRAINT PDP_PROC_SUM_TR2
    FOREIGN KEY (CUST_ID)
    REFERENCES PDP_CUST_PRFL_T (CUST_ID)
/

ALTER TABLE PDP_PROC_SUM_T
    ADD CONSTRAINT PDP_PROC_SUM_TR3
    FOREIGN KEY (DISB_TYP_CD)
    REFERENCES PDP_DISB_TYP_CD_T (DISB_TYP_CD)
/

ALTER TABLE PUR_AP_ORG_PARM_T
    ADD CONSTRAINT PUR_AP_ORG_PARM_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_ASGN_CONTR_MGR_DTL_T
    ADD CONSTRAINT PUR_ASGN_CONTR_MGR_DTL_TR1
    FOREIGN KEY (REQS_ID)
    REFERENCES PUR_REQS_T (REQS_ID)
/

ALTER TABLE PUR_ASGN_CONTR_MGR_DTL_T
    ADD CONSTRAINT PUR_ASGN_CONTR_MGR_DTL_TR2
    FOREIGN KEY (CONTR_MGR_CD)
    REFERENCES PUR_CONTR_MGR_T (CONTR_MGR_CD)
/

ALTER TABLE PUR_ASGN_CONTR_MGR_DTL_T
    ADD CONSTRAINT PUR_ASGN_CONTR_MGR_DTL_TR3
    FOREIGN KEY (FDOC_NBR)
    REFERENCES PUR_ASGN_CONTR_MGR_T (FDOC_NBR)
/

ALTER TABLE PUR_BLK_RCVNG_T
    ADD CONSTRAINT PUR_BLK_RCVNG_T4
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_BLK_RCVNG_T
    ADD CONSTRAINT PUR_BLK_RCVNG_TR3
    FOREIGN KEY (CARI_CD)
    REFERENCES PUR_CARI_T (CARI_CD)
/

ALTER TABLE PUR_COMM_CONTR_MGR_T
    ADD CONSTRAINT PUR_COMM_CONTR_MGR_TR1
    FOREIGN KEY (PUR_COMM_CD)
    REFERENCES PUR_COMM_T (PUR_COMM_CD)
/

ALTER TABLE PUR_COMM_CONTR_MGR_T
    ADD CONSTRAINT PUR_COMM_CONTR_MGR_TR3
    FOREIGN KEY (CONTR_MGR_CD)
    REFERENCES PUR_CONTR_MGR_T (CONTR_MGR_CD)
/

ALTER TABLE PUR_DFLT_PRNCPL_ADDR_T
    ADD CONSTRAINT PUR_DFLT_PRNCPL_ADDR_TR2
    FOREIGN KEY (CAMPUS_CD, BLDG_CD)
    REFERENCES SH_BUILDING_T (CAMPUS_CD, BLDG_CD)
/

ALTER TABLE PUR_PO_ACCT_T
    ADD CONSTRAINT PUR_PO_ACCT_TR1
    FOREIGN KEY (FDOC_NBR, PO_ITM_ID)
    REFERENCES PUR_PO_ITM_T (FDOC_NBR, PO_ITM_ID)
/

ALTER TABLE PUR_PO_ACCT_T
    ADD CONSTRAINT PUR_PO_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_PO_ACCT_T
    ADD CONSTRAINT PUR_PO_ACCT_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE PUR_PO_ACCT_T
    ADD CONSTRAINT PUR_PO_ACCT_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE PUR_PO_CPTL_AST_ITM_AST_T
    ADD CONSTRAINT PUR_PO_CPTL_AST_ITM_AST_TR1
    FOREIGN KEY (CPTL_AST_SYS_ID)
    REFERENCES PUR_PO_CPTL_AST_SYS_T (CPTL_AST_SYS_ID)
/

ALTER TABLE PUR_PO_CPTL_AST_ITM_T
    ADD CONSTRAINT PUR_PO_CPTL_AST_ITM_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES PUR_PO_T (FDOC_NBR)
/

ALTER TABLE PUR_PO_CPTL_AST_ITM_T
    ADD CONSTRAINT PUR_PO_CPTL_AST_ITM_TR2
    FOREIGN KEY (FDOC_NBR, PO_ITM_ID)
    REFERENCES PUR_PO_ITM_T (FDOC_NBR, PO_ITM_ID)
/

ALTER TABLE PUR_PO_CPTL_AST_ITM_T
    ADD CONSTRAINT PUR_PO_CPTL_AST_ITM_TR4
    FOREIGN KEY (CPTL_AST_SYS_ID)
    REFERENCES PUR_PO_CPTL_AST_SYS_T (CPTL_AST_SYS_ID)
/

ALTER TABLE PUR_PO_CPTL_AST_LOC_T
    ADD CONSTRAINT PUR_PO_CPTL_AST_LOC_TR1
    FOREIGN KEY (CPTL_AST_SYS_ID)
    REFERENCES PUR_PO_CPTL_AST_SYS_T (CPTL_AST_SYS_ID)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES PUR_PO_T (FDOC_NBR)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR2
    FOREIGN KEY (ITM_TYP_CD)
    REFERENCES PUR_AP_ITM_TYP_T (ITM_TYP_CD)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR3
    FOREIGN KEY (OLE_ITM_PRC_SRC_ID)
    REFERENCES OLE_ITM_PRC_SRC_T (ITM_PRC_SRC_ID)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR4
    FOREIGN KEY (PUR_COMM_CD)
    REFERENCES PUR_COMM_T (PUR_COMM_CD)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR7
    FOREIGN KEY (OLE_PO_IT_ORDR_STAT_ID)
    REFERENCES OLE_PUR_PO_ITM_ORDR_STAT_T (OLE_PO_ITM_ORDR_STAT_ID)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR8
    FOREIGN KEY (OLE_RQSTR_TYP_ID)
    REFERENCES OLE_RQSTR_TYP_T (OLE_RQSTR_TYP_ID)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR10
    FOREIGN KEY (OLE_REQ_RCPT_STATUS_ID)
    REFERENCES OLE_PUR_REQ_RCPT_STATUS_T (OLE_REQ_RCPT_STATUS_ID)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR11
    FOREIGN KEY (OLE_FRMT_ID)
    REFERENCES OLE_PUR_FRMT_T (OLE_FRMT_ID)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR12
    FOREIGN KEY (OLE_CAT_ID)
    REFERENCES OLE_PUR_CAT_T (OLE_CAT_ID)
/

ALTER TABLE PUR_PO_ITM_T
    ADD CONSTRAINT PUR_PO_ITM_TR13
    FOREIGN KEY (OLE_REQ_SRC_TYP_ID)
    REFERENCES OLE_PUR_REQ_SRC_TYP_T (OLE_REQ_SRC_TYP_ID)
/

ALTER TABLE PUR_PO_QT_LST_VNDR_T
    ADD CONSTRAINT PUR_PO_QT_LST_VNDR_TR1
    FOREIGN KEY (PO_QT_LST_ID)
    REFERENCES PUR_PO_QT_LST_T (PO_QT_LST_ID)
/

ALTER TABLE PUR_PO_SNSTV_DTA_T
    ADD CONSTRAINT PUR_PO_SNSTV_DTA_TR1
    FOREIGN KEY (SNSTV_DTA_CD)
    REFERENCES PUR_SNSTV_DTA_T (SNSTV_DTA_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT LIC_RQMT_FK1
    FOREIGN KEY (LIC_RQMT_CD)
    REFERENCES OLE_LIC_RQMT_T (LIC_RQMT_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR1
    FOREIGN KEY (VNDR_DTL_ASND_ID, VNDR_HDR_GNRTD_ID, OLE_VNDR_TRANS_FRMT_ID, OLE_TRANS_TYP_ID)
    REFERENCES OLE_VNDR_TRANS_FRMT_TYP_INT_T (VNDR_DTL_ASND_ID, VNDR_HDR_GNRTD_ID, OLE_VNDR_TRANS_FRMT_ID, OLE_TRANS_TYP_ID)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR10
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR11
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR13
    FOREIGN KEY (NON_INST_FND_ORG_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR14
    FOREIGN KEY (NON_INST_FND_COA_CD, NON_INST_FND_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR15
    FOREIGN KEY (NON_INST_FND_COA_CD, NON_INST_FND_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR16
    FOREIGN KEY (NON_INST_FND_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR17
    FOREIGN KEY (VNDR_CONTR_GNRTD_ID)
    REFERENCES PUR_VNDR_CONTR_T (VNDR_CONTR_GNRTD_ID)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR18
    FOREIGN KEY (PO_VNDR_CHC_CD)
    REFERENCES PUR_PO_VNDR_CHC_T (PO_VNDR_CHC_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR19
    FOREIGN KEY (RECUR_PMT_FREQ_CD)
    REFERENCES PUR_AP_RECUR_PMT_FREQ_T (RECUR_PMT_FREQ_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR20
    FOREIGN KEY (VNDR_PMT_TERM_CD)
    REFERENCES PUR_PMT_TERM_TYP_T (VNDR_PMT_TERM_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR21
    FOREIGN KEY (VNDR_SHP_TTL_CD)
    REFERENCES PUR_SHP_TTL_T (VNDR_SHP_TTL_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR22
    FOREIGN KEY (VNDR_SHP_PMT_TERM_CD)
    REFERENCES PUR_SHP_PMT_TERM_T (VNDR_SHP_PMT_TERM_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR24
    FOREIGN KEY (CONTR_MGR_CD)
    REFERENCES PUR_CONTR_MGR_T (CONTR_MGR_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR25
    FOREIGN KEY (CPTL_AST_SYS_TYP_CD)
    REFERENCES PUR_CPTL_AST_SYS_TYP_T (CPTL_AST_SYS_TYP_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR26
    FOREIGN KEY (CPTL_AST_SYS_ST_CD)
    REFERENCES PUR_CPTL_AST_SYS_ST_T (CPTL_AST_SYS_ST_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR3
    FOREIGN KEY (OLE_PO_TYPE_ID)
    REFERENCES OLE_PUR_PO_TYP_T (OLE_PO_TYPE_ID)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR4
    FOREIGN KEY (FND_SRC_CD)
    REFERENCES PUR_FND_SRC_T (FND_SRC_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR5
    FOREIGN KEY (REQS_SRC_CD)
    REFERENCES PUR_REQS_SRC_T (REQS_SRC_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR6
    FOREIGN KEY (PO_TRNS_MTHD_CD)
    REFERENCES PUR_PO_TRNS_MTHD_T (PO_TRNS_MTHD_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR7
    FOREIGN KEY (PO_CST_SRC_CD)
    REFERENCES PUR_PO_CST_SRC_T (PO_CST_SRC_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR8
    FOREIGN KEY (DLVY_REQ_DT_REAS_CD)
    REFERENCES PUR_DLVY_REQ_DT_REAS_T (DLVY_REQ_DT_REAS_CD)
/

ALTER TABLE PUR_PO_T
    ADD CONSTRAINT PUR_PO_TR9
    FOREIGN KEY (RECUR_PMT_TYP_CD)
    REFERENCES PUR_AP_RECUR_PMT_TYP_T (RECUR_PMT_TYP_CD)
/

ALTER TABLE PUR_PO_VNDR_QT_T
    ADD CONSTRAINT PUR_PO_VNDR_QT_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES PUR_PO_T (FDOC_NBR)
/

ALTER TABLE PUR_PO_VNDR_QT_T
    ADD CONSTRAINT PUR_PO_VNDR_QT_TR2
    FOREIGN KEY (PO_QT_STAT_CD)
    REFERENCES PUR_PO_QT_STAT_T (PO_QT_STAT_CD)
/

ALTER TABLE PUR_PO_VNDR_STPLTN_T
    ADD CONSTRAINT PUR_PO_VNDR_STPLTN_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES PUR_PO_T (FDOC_NBR)
/

ALTER TABLE PUR_RCVNG_ADDR_T
    ADD CONSTRAINT PUR_RCVNG_ADDR_TR1
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_RCVNG_ADDR_T
    ADD CONSTRAINT PUR_RCVNG_ADDR_TR2
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_RCVNG_COR_ITM_T
    ADD CONSTRAINT PUR_RCVNG_COR_ITM_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES PUR_RCVNG_COR_T (FDOC_NBR)
/

ALTER TABLE PUR_RCVNG_COR_ITM_T
    ADD CONSTRAINT PUR_RCVNG_COR_ITM_TR2
    FOREIGN KEY (ITM_REAS_ADD_CD)
    REFERENCES PUR_ITM_REAS_ADD_T (ITM_REAS_ADD_CD)
/

ALTER TABLE PUR_RCVNG_COR_ITM_T
    ADD CONSTRAINT PUR_RCVNG_COR_ITM_TR3
    FOREIGN KEY (ITM_TYP_CD)
    REFERENCES PUR_AP_ITM_TYP_T (ITM_TYP_CD)
/

ALTER TABLE PUR_RCVNG_COR_ITM_T
    ADD CONSTRAINT PUR_RCVNG_COR_ITM_TR4
    FOREIGN KEY (ITM_UOM_CD)
    REFERENCES SH_UOM_T (ITM_UOM_CD)
/

ALTER TABLE PUR_RCVNG_COR_ITM_T
    ADD CONSTRAINT PUR_RCVNG_COR_ITM_TR5
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_RCVNG_COR_T
    ADD CONSTRAINT PUR_RCVNG_COR_TR1
    FOREIGN KEY (RCVNG_LN_FDOC_NBR)
    REFERENCES PUR_RCVNG_LN_T (FDOC_NBR)
/

ALTER TABLE PUR_RCVNG_LN_ITM_T
    ADD CONSTRAINT PUR_RCVNG_LN_ITM_TR7
    FOREIGN KEY (OLE_REQ_RCPT_STATUS_ID)
    REFERENCES OLE_PUR_REQ_RCPT_STATUS_T (OLE_REQ_RCPT_STATUS_ID)
/

ALTER TABLE PUR_RCVNG_LN_ITM_T
    ADD CONSTRAINT PUR_RCVNG_LN_ITM_TR1
    FOREIGN KEY (FDOC_NBR)
    REFERENCES PUR_RCVNG_LN_T (FDOC_NBR)
/

ALTER TABLE PUR_RCVNG_LN_ITM_T
    ADD CONSTRAINT PUR_RCVNG_LN_ITM_TR2
    FOREIGN KEY (ITM_REAS_ADD_CD)
    REFERENCES PUR_ITM_REAS_ADD_T (ITM_REAS_ADD_CD)
/

ALTER TABLE PUR_RCVNG_LN_ITM_T
    ADD CONSTRAINT PUR_RCVNG_LN_ITM_TR3
    FOREIGN KEY (ITM_TYP_CD)
    REFERENCES PUR_AP_ITM_TYP_T (ITM_TYP_CD)
/

ALTER TABLE PUR_RCVNG_LN_ITM_T
    ADD CONSTRAINT PUR_RCVNG_LN_ITM_TR4
    FOREIGN KEY (ITM_UOM_CD)
    REFERENCES SH_UOM_T (ITM_UOM_CD)
/

ALTER TABLE PUR_RCVNG_LN_ITM_T
    ADD CONSTRAINT PUR_RCVNG_LN_ITM_TR5
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_RCVNG_LN_ITM_T
    ADD CONSTRAINT PUR_RCVNG_LN_ITM_TR6
    FOREIGN KEY (OLE_FRMT_ID)
    REFERENCES OLE_PUR_FRMT_T (OLE_FRMT_ID)
/

ALTER TABLE PUR_RCVNG_LN_T
    ADD CONSTRAINT PUR_RCVNG_LN_TR1
    FOREIGN KEY (RCVNG_LN_STAT_CD)
    REFERENCES PUR_RCVNG_LN_STAT_T (RCVNG_LN_STAT_CD)
/

ALTER TABLE PUR_RCVNG_LN_T
    ADD CONSTRAINT PUR_RCVNG_LN_TR4
    FOREIGN KEY (CARI_CD)
    REFERENCES PUR_CARI_T (CARI_CD)
/

ALTER TABLE PUR_RCVNG_LN_T
    ADD CONSTRAINT PUR_RCVNG_LN_TR5
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_RCVNG_LN_T
    ADD CONSTRAINT PUR_RCVNG_LN_TR6
    FOREIGN KEY (DLVY_REQ_DT_REAS_CD)
    REFERENCES PUR_DLVY_REQ_DT_REAS_T (DLVY_REQ_DT_REAS_CD)
/

ALTER TABLE PUR_REQS_ACCT_T
    ADD CONSTRAINT PUR_REQS_ACCT_TR1
    FOREIGN KEY (REQS_ITM_ID)
    REFERENCES PUR_REQS_ITM_T (REQS_ITM_ID)
/

ALTER TABLE PUR_REQS_ACCT_T
    ADD CONSTRAINT PUR_REQS_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_REQS_ACCT_T
    ADD CONSTRAINT PUR_REQS_ACCT_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE PUR_REQS_ACCT_T
    ADD CONSTRAINT PUR_REQS_ACCT_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE PUR_REQS_CPTL_AST_ITM_AST_T
    ADD CONSTRAINT PUR_REQS_CPTL_AST_ITM_AST_TR2
    FOREIGN KEY (CPTL_AST_SYS_ID)
    REFERENCES PUR_REQS_CPTL_AST_SYS_T (CPTL_AST_SYS_ID)
/

ALTER TABLE PUR_REQS_CPTL_AST_ITM_T
    ADD CONSTRAINT PUR_REQS_CPTL_AST_ITM_TR1
    FOREIGN KEY (REQS_ID)
    REFERENCES PUR_REQS_T (REQS_ID)
/

ALTER TABLE PUR_REQS_CPTL_AST_ITM_T
    ADD CONSTRAINT PUR_REQS_CPTL_AST_ITM_TR3
    FOREIGN KEY (CPTL_AST_SYS_ID)
    REFERENCES PUR_REQS_CPTL_AST_SYS_T (CPTL_AST_SYS_ID)
/

ALTER TABLE PUR_REQS_CPTL_AST_ITM_T
    ADD CONSTRAINT PUR_REQS_CPTL_AST_ITM_TR4
    FOREIGN KEY (REQS_ITM_ID)
    REFERENCES PUR_REQS_ITM_T (REQS_ITM_ID)
/

ALTER TABLE PUR_REQS_CPTL_AST_LOC_T
    ADD CONSTRAINT PUR_REQS_CPTL_AST_LOC_TR2
    FOREIGN KEY (CPTL_AST_SYS_ID)
    REFERENCES PUR_REQS_CPTL_AST_SYS_T (CPTL_AST_SYS_ID)
/

ALTER TABLE PUR_REQS_CPTL_AST_SYS_T
    ADD CONSTRAINT PUR_REQS_CPTL_AST_SYS_TR1
    FOREIGN KEY (REQS_ID)
    REFERENCES PUR_REQS_T (REQS_ID)
/

ALTER TABLE PUR_REQS_ITM_T
    ADD CONSTRAINT PUR_REQS_ITM_TR2
    FOREIGN KEY (OLE_PO_TYPE_ID)
    REFERENCES OLE_PUR_PO_TYP_T (OLE_PO_TYPE_ID)
/

ALTER TABLE PUR_REQS_ITM_T
    ADD CONSTRAINT PUR_REQS_ITM_TR3
    FOREIGN KEY (ITM_TYP_CD)
    REFERENCES PUR_AP_ITM_TYP_T (ITM_TYP_CD)
/

ALTER TABLE PUR_REQS_ITM_T
    ADD CONSTRAINT PUR_REQS_ITM_TR4
    FOREIGN KEY (PUR_COMM_CD)
    REFERENCES PUR_COMM_T (PUR_COMM_CD)
/

ALTER TABLE PUR_REQS_ITM_T
    ADD CONSTRAINT PUR_REQS_ITM_TR7
    FOREIGN KEY (OLE_RQSTR_TYP_ID)
    REFERENCES OLE_RQSTR_TYP_T (OLE_RQSTR_TYP_ID)
/

ALTER TABLE PUR_REQS_ITM_T
    ADD CONSTRAINT PUR_REQS_ITM_TR8
    FOREIGN KEY (OLE_ITM_PRC_SRC_ID)
    REFERENCES OLE_ITM_PRC_SRC_T (ITM_PRC_SRC_ID)
/

ALTER TABLE PUR_REQS_ITM_T
    ADD CONSTRAINT PUR_REQS_ITM_TR1
    FOREIGN KEY (OLE_REQ_RCPT_STATUS_ID)
    REFERENCES OLE_PUR_REQ_RCPT_STATUS_T (OLE_REQ_RCPT_STATUS_ID)
/

ALTER TABLE PUR_REQS_ITM_T
    ADD CONSTRAINT PUR_REQS_ITM_TR10
    FOREIGN KEY (OLE_FRMT_ID)
    REFERENCES OLE_PUR_FRMT_T (OLE_FRMT_ID)
/

ALTER TABLE PUR_REQS_ITM_T
    ADD CONSTRAINT PUR_REQS_ITM_TR5
    FOREIGN KEY (OLE_CAT_ID)
    REFERENCES OLE_PUR_CAT_T (OLE_CAT_ID)
/

ALTER TABLE PUR_REQS_ITM_T
    ADD CONSTRAINT PUR_REQS_ITM_TR6
    FOREIGN KEY (OLE_REQ_SRC_TYP_ID)
    REFERENCES OLE_PUR_REQ_SRC_TYP_T (OLE_REQ_SRC_TYP_ID)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT LIC_RQMT_FK
    FOREIGN KEY (LIC_RQMT_CD)
    REFERENCES OLE_LIC_RQMT_T (LIC_RQMT_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR1
    FOREIGN KEY (VNDR_DTL_ASND_ID, VNDR_HDR_GNRTD_ID, OLE_VNDR_TRANS_FRMT_ID, OLE_TRANS_TYP_ID)
    REFERENCES OLE_VNDR_TRANS_FRMT_TYP_INT_T (VNDR_DTL_ASND_ID, VNDR_HDR_GNRTD_ID, OLE_VNDR_TRANS_FRMT_ID, OLE_TRANS_TYP_ID)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR10
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR11
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR13
    FOREIGN KEY (NON_INST_FND_ORG_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR14
    FOREIGN KEY (NON_INST_FND_COA_CD, NON_INST_FND_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR15
    FOREIGN KEY (NON_INST_FND_COA_CD, NON_INST_FND_ACCT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR16
    FOREIGN KEY (NON_INST_FND_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR17
    FOREIGN KEY (VNDR_CONTR_GNRTD_ID)
    REFERENCES PUR_VNDR_CONTR_T (VNDR_CONTR_GNRTD_ID)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR20
    FOREIGN KEY (CPTL_AST_SYS_TYP_CD)
    REFERENCES PUR_CPTL_AST_SYS_TYP_T (CPTL_AST_SYS_TYP_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR3
    FOREIGN KEY (OLE_PO_TYPE_ID)
    REFERENCES OLE_PUR_PO_TYP_T (OLE_PO_TYPE_ID)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR4
    FOREIGN KEY (FND_SRC_CD)
    REFERENCES PUR_FND_SRC_T (FND_SRC_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR5
    FOREIGN KEY (REQS_SRC_CD)
    REFERENCES PUR_REQS_SRC_T (REQS_SRC_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR6
    FOREIGN KEY (PO_TRNS_MTHD_CD)
    REFERENCES PUR_PO_TRNS_MTHD_T (PO_TRNS_MTHD_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR7
    FOREIGN KEY (PO_CST_SRC_CD)
    REFERENCES PUR_PO_CST_SRC_T (PO_CST_SRC_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR8
    FOREIGN KEY (DLVY_REQ_DT_REAS_CD)
    REFERENCES PUR_DLVY_REQ_DT_REAS_T (DLVY_REQ_DT_REAS_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR89
    FOREIGN KEY (CPTL_AST_SYS_ST_CD)
    REFERENCES PUR_CPTL_AST_SYS_ST_T (CPTL_AST_SYS_ST_CD)
/

ALTER TABLE PUR_REQS_T
    ADD CONSTRAINT PUR_REQS_TR9
    FOREIGN KEY (RECUR_PMT_TYP_CD)
    REFERENCES PUR_AP_RECUR_PMT_TYP_T (RECUR_PMT_TYP_CD)
/

ALTER TABLE PUR_SNSTV_DTA_ASGN_DTL_T
    ADD CONSTRAINT PUR_SNSTV_DTA_ASGN_DTL_TR1
    FOREIGN KEY (SNSTV_DTA_ASGN_ID)
    REFERENCES PUR_SNSTV_DTA_ASGN_T (SNSTV_DTA_ASGN_ID)
/

ALTER TABLE PUR_SNSTV_DTA_ASGN_DTL_T
    ADD CONSTRAINT PUR_SNSTV_DTA_ASGN_DTL_TR2
    FOREIGN KEY (SNSTV_DTA_CD)
    REFERENCES PUR_SNSTV_DTA_T (SNSTV_DTA_CD)
/

ALTER TABLE PUR_THRSHLD_T
    ADD CONSTRAINT PUR_THRSHLD_TR1
    FOREIGN KEY (ACCT_TYP_CD)
    REFERENCES CA_ACCOUNT_TYPE_T (ACCT_TYP_CD)
/

ALTER TABLE PUR_THRSHLD_T
    ADD CONSTRAINT PUR_THRSHLD_TR2
    FOREIGN KEY (SUB_FUND_GRP_CD)
    REFERENCES CA_SUB_FUND_GRP_T (SUB_FUND_GRP_CD)
/

ALTER TABLE PUR_THRSHLD_T
    ADD CONSTRAINT PUR_THRSHLD_TR3
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_THRSHLD_T
    ADD CONSTRAINT PUR_THRSHLD_TR4
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_THRSHLD_T
    ADD CONSTRAINT PUR_THRSHLD_TR5
    FOREIGN KEY (PUR_COMM_CD)
    REFERENCES PUR_COMM_T (PUR_COMM_CD)
/

ALTER TABLE PUR_THRSHLD_T
    ADD CONSTRAINT PUR_THRSHLD_TR6
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_VNDR_ADDR_T
    ADD CONSTRAINT PUR_VNDR_ADDR_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_ADDR_T
    ADD CONSTRAINT PUR_VNDR_ADDR_TR2
    FOREIGN KEY (VNDR_ADDR_TYP_CD)
    REFERENCES PUR_ADDR_TYP_T (VNDR_ADDR_TYP_CD)
/

ALTER TABLE PUR_VNDR_ALIAS_T
    ADD CONSTRAINT PUR_VNDR_ALIAS_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_ALIAS_T
    ADD CONSTRAINT PUR_VNDR_ALIAS_TR2
    FOREIGN KEY (OLE_ALIAS_TYP_ID)
    REFERENCES OLE_VNDR_ALIAS_TYP_T (OLE_ALIAS_TYP_ID)
/

ALTER TABLE PUR_VNDR_CNTCT_PHN_NBR_T
    ADD CONSTRAINT PUR_VNDR_CNTCT_PHN_NBR_TR1
    FOREIGN KEY (VNDR_PHN_TYP_CD)
    REFERENCES PUR_PHN_TYP_T (VNDR_PHN_TYP_CD)
/

ALTER TABLE PUR_VNDR_CNTCT_PHN_NBR_T
    ADD CONSTRAINT PUR_VNDR_CNTCT_PHN_NBR_TR2
    FOREIGN KEY (VNDR_CNTCT_GNRTD_ID)
    REFERENCES PUR_VNDR_CNTCT_T (VNDR_CNTCT_GNRTD_ID)
/

ALTER TABLE PUR_VNDR_CNTCT_T
    ADD CONSTRAINT PUR_VNDR_CNTCT_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_CNTCT_T
    ADD CONSTRAINT PUR_VNDR_CNTCT_TR2
    FOREIGN KEY (VNDR_CNTCT_TYP_CD)
    REFERENCES PUR_CNTCT_TYP_T (VNDR_CNTCT_TYP_CD)
/

ALTER TABLE PUR_VNDR_COMM_T
    ADD CONSTRAINT PUR_VNDR_COMM_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_CONTR_ORG_T
    ADD CONSTRAINT PUR_VNDR_CONTR_ORG_TR1
    FOREIGN KEY (VNDR_CONTR_GNRTD_ID)
    REFERENCES PUR_VNDR_CONTR_T (VNDR_CONTR_GNRTD_ID)
/

ALTER TABLE PUR_VNDR_CONTR_ORG_T
    ADD CONSTRAINT PUR_VNDR_CONTR_ORG_TR2
    FOREIGN KEY (FIN_COA_CD, ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_VNDR_CONTR_ORG_T
    ADD CONSTRAINT PUR_VNDR_CONTR_ORG_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_VNDR_CONTR_T
    ADD CONSTRAINT PUR_VNDR_CONTR_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_CONTR_T
    ADD CONSTRAINT PUR_VNDR_CONTR_TR3
    FOREIGN KEY (CONTR_MGR_CD)
    REFERENCES PUR_CONTR_MGR_T (CONTR_MGR_CD)
/

ALTER TABLE PUR_VNDR_CONTR_T
    ADD CONSTRAINT PUR_VNDR_CONTR_TR4
    FOREIGN KEY (PO_CST_SRC_CD)
    REFERENCES PUR_PO_CST_SRC_T (PO_CST_SRC_CD)
/

ALTER TABLE PUR_VNDR_CONTR_T
    ADD CONSTRAINT PUR_VNDR_CONTR_TR5
    FOREIGN KEY (VNDR_PMT_TERM_CD)
    REFERENCES PUR_PMT_TERM_TYP_T (VNDR_PMT_TERM_CD)
/

ALTER TABLE PUR_VNDR_CONTR_T
    ADD CONSTRAINT PUR_VNDR_CONTR_TR6
    FOREIGN KEY (VNDR_SHP_PMT_TERM_CD)
    REFERENCES PUR_SHP_PMT_TERM_T (VNDR_SHP_PMT_TERM_CD)
/

ALTER TABLE PUR_VNDR_CONTR_T
    ADD CONSTRAINT PUR_VNDR_CONTR_TR7
    FOREIGN KEY (VNDR_SHP_TTL_CD)
    REFERENCES PUR_SHP_TTL_T (VNDR_SHP_TTL_CD)
/

ALTER TABLE PUR_VNDR_CUST_NBR_T
    ADD CONSTRAINT NDR_CUST_NBR_TR4
    FOREIGN KEY (CARI_CD)
    REFERENCES PUR_CARI_T (CARI_CD)
/

ALTER TABLE PUR_VNDR_CUST_NBR_T
    ADD CONSTRAINT PUR_VNDR_CUST_NBR_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_CUST_NBR_T
    ADD CONSTRAINT PUR_VNDR_CUST_NBR_TR2
    FOREIGN KEY (FIN_COA_CD, VNDR_ORG_CD)
    REFERENCES CA_ORG_T (FIN_COA_CD, ORG_CD)
/

ALTER TABLE PUR_VNDR_CUST_NBR_T
    ADD CONSTRAINT PUR_VNDR_CUST_NBR_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE PUR_VNDR_DFLT_ADDR_T
    ADD CONSTRAINT PUR_VNDR_DFLT_ADDR_TR4
    FOREIGN KEY (VNDR_ADDR_GNRTD_ID)
    REFERENCES PUR_VNDR_ADDR_T (VNDR_ADDR_GNRTD_ID)
/

ALTER TABLE PUR_VNDR_DTL_T
    ADD CONSTRAINT PUR_VNDR_DTL_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID)
    REFERENCES PUR_VNDR_HDR_T (VNDR_HDR_GNRTD_ID)
/

ALTER TABLE PUR_VNDR_DTL_T
    ADD CONSTRAINT PUR_VNDR_DTL_TR2
    FOREIGN KEY (VNDR_INACTV_REAS_CD)
    REFERENCES PUR_VNDR_INACTV_REAS_T (VNDR_INACTV_REAS_CD)
/

ALTER TABLE PUR_VNDR_DTL_T
    ADD CONSTRAINT PUR_VNDR_DTL_TR3
    FOREIGN KEY (VNDR_PMT_TERM_CD)
    REFERENCES PUR_PMT_TERM_TYP_T (VNDR_PMT_TERM_CD)
/

ALTER TABLE PUR_VNDR_DTL_T
    ADD CONSTRAINT PUR_VNDR_DTL_TR4
    FOREIGN KEY (VNDR_SHP_TTL_CD)
    REFERENCES PUR_SHP_TTL_T (VNDR_SHP_TTL_CD)
/

ALTER TABLE PUR_VNDR_DTL_T
    ADD CONSTRAINT PUR_VNDR_DTL_TR5
    FOREIGN KEY (VNDR_SHP_PMT_TERM_CD)
    REFERENCES PUR_SHP_PMT_TERM_T (VNDR_SHP_PMT_TERM_CD)
/

ALTER TABLE PUR_VNDR_DTL_T
    ADD CONSTRAINT PUR_VNDR_DTL_TR6
    FOREIGN KEY (VNDR_SOLD_TO_GNRTD_ID, VNDR_SOLD_TO_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_DTL_T
    ADD CONSTRAINT PUR_VND_DTL_CURR_TYP_FR
    FOREIGN KEY (OLE_CURR_TYP_ID)
    REFERENCES OLE_CURR_TYP_T (OLE_CURR_TYP_ID)
/

ALTER TABLE PUR_VNDR_DTL_T
    ADD CONSTRAINT VNDR_PMT_MTHD_FK
    FOREIGN KEY (VNDR_PMT_MTHD_ID)
    REFERENCES OLE_PMT_MTHD_T (OLE_PMT_MTHD_ID)
/

ALTER TABLE PUR_VNDR_EXCL_MTCH_T
    ADD CONSTRAINT PUR_VNDR_EXCL_MTCH_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID)
    REFERENCES PUR_VNDR_HDR_T (VNDR_HDR_GNRTD_ID)
/

ALTER TABLE PUR_VNDR_EXCL_MTCH_T
    ADD CONSTRAINT PUR_VNDR_EXCL_MTCH_TR2
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_HDR_T
    ADD CONSTRAINT PUR_VNDR_HDR_TR1
    FOREIGN KEY (VNDR_TYP_CD)
    REFERENCES PUR_VNDR_TYP_T (VNDR_TYP_CD)
/

ALTER TABLE PUR_VNDR_HDR_T
    ADD CONSTRAINT PUR_VNDR_HDR_TR2
    FOREIGN KEY (VNDR_OWNR_CD)
    REFERENCES PUR_OWNR_TYP_T (VNDR_OWNR_CD)
/

ALTER TABLE PUR_VNDR_HDR_T
    ADD CONSTRAINT PUR_VNDR_HDR_TR3
    FOREIGN KEY (VNDR_OWNR_CTGRY_CD)
    REFERENCES PUR_OWNR_CTGRY_T (VNDR_OWNR_CTGRY_CD)
/

ALTER TABLE PUR_VNDR_PHN_NBR_T
    ADD CONSTRAINT PUR_VNDR_PHN_NBR_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_PHN_NBR_T
    ADD CONSTRAINT PUR_VNDR_PHN_NBR_TR2
    FOREIGN KEY (VNDR_PHN_TYP_CD)
    REFERENCES PUR_PHN_TYP_T (VNDR_PHN_TYP_CD)
/

ALTER TABLE PUR_VNDR_SHP_SPCL_COND_T
    ADD CONSTRAINT PUR_VNDR_SHP_SPCL_COND_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE PUR_VNDR_SHP_SPCL_COND_T
    ADD CONSTRAINT PUR_VNDR_SHP_SPCL_COND_TR2
    FOREIGN KEY (VNDR_SHP_SPCL_COND_CD)
    REFERENCES PUR_SHP_SPCL_COND_T (VNDR_SHP_SPCL_COND_CD)
/

ALTER TABLE PUR_VNDR_SUPP_DVRST_T
    ADD CONSTRAINT PUR_VNDR_SUPP_DVRST_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID)
    REFERENCES PUR_VNDR_HDR_T (VNDR_HDR_GNRTD_ID)
/

ALTER TABLE PUR_VNDR_SUPP_DVRST_T
    ADD CONSTRAINT PUR_VNDR_SUPP_DVRST_TR2
    FOREIGN KEY (VNDR_SUPP_DVRST_CD)
    REFERENCES PUR_SUPP_DVRST_T (VNDR_SUPP_DVRST_CD)
/

ALTER TABLE PUR_VNDR_TAX_CHG_T
    ADD CONSTRAINT PUR_VNDR_TAX_CHG_TR1
    FOREIGN KEY (VNDR_HDR_GNRTD_ID)
    REFERENCES PUR_VNDR_HDR_T (VNDR_HDR_GNRTD_ID)
/

ALTER TABLE PUR_VNDR_TYP_T
    ADD CONSTRAINT PUR_VNDR_TYP_TR1
    FOREIGN KEY (VNDR_ADDR_TYP_REQ_CD)
    REFERENCES PUR_ADDR_TYP_T (VNDR_ADDR_TYP_CD)
/

ALTER TABLE QRTZ_BLOB_TRIGGERS
    ADD CONSTRAINT SYS_C0092243
    FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP)
    REFERENCES QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP)
/

ALTER TABLE QRTZ_CRON_TRIGGERS
    ADD CONSTRAINT SYS_C0091987
    FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP)
    REFERENCES QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP)
/

ALTER TABLE QRTZ_JOB_LISTENERS
    ADD CONSTRAINT SYS_C0091985
    FOREIGN KEY (JOB_NAME, JOB_GROUP)
    REFERENCES QRTZ_JOB_DETAILS (JOB_NAME, JOB_GROUP)
/

ALTER TABLE QRTZ_SIMPLE_TRIGGERS
    ADD CONSTRAINT SYS_C0091986
    FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP)
    REFERENCES QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP)
/

ALTER TABLE QRTZ_TRIGGERS
    ADD CONSTRAINT SYS_C0092242
    FOREIGN KEY (JOB_NAME, JOB_GROUP)
    REFERENCES QRTZ_JOB_DETAILS (JOB_NAME, JOB_GROUP)
/

ALTER TABLE QRTZ_TRIGGER_LISTENERS
    ADD CONSTRAINT SYS_C0091988
    FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP)
    REFERENCES QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP)
/

ALTER TABLE SH_ACCT_PERIOD_T
    ADD CONSTRAINT SH_ACCT_PERIOD_TR1
    FOREIGN KEY (UNIV_FISCAL_YR)
    REFERENCES FS_OPTION_T (UNIV_FISCAL_YR)
/

ALTER TABLE OLE_AP_INV_T
    ADD CONSTRAINT OLE_AP_INV_TR1
    FOREIGN KEY (BNK_CD)
    REFERENCES FP_BANK_T (BNK_CD)
/

ALTER TABLE OLE_AP_INV_T
    ADD CONSTRAINT OLE_AP_INV_TR10
    FOREIGN KEY (OLE_PMT_MTHD_ID)
    REFERENCES OLE_PMT_MTHD_T (OLE_PMT_MTHD_ID)
/

ALTER TABLE OLE_AP_INV_T
    ADD CONSTRAINT OLE_AP_INV_CURR_TR15
    FOREIGN KEY (OLE_CURR_TYP_ID)
    REFERENCES OLE_CURR_TYP_T (OLE_CURR_TYP_ID)
/

ALTER TABLE OLE_AP_INV_T
    ADD CONSTRAINT OLE_AP_INV_TR3
    FOREIGN KEY (OLE_INV_TYP_ID)
    REFERENCES OLE_INV_TYP_T (OLE_INV_TYP_ID)
/

ALTER TABLE OLE_AP_INV_T
    ADD CONSTRAINT OLE_AP_INV_TR4
    FOREIGN KEY (OLE_INV_SUB_TYP_ID)
    REFERENCES OLE_INV_SUB_TYP_T (OLE_INV_SUB_TYP_ID)
/

ALTER TABLE OLE_AP_INV_T
    ADD CONSTRAINT OLE_AP_INV_TR5
    FOREIGN KEY (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
    REFERENCES PUR_VNDR_DTL_T (VNDR_HDR_GNRTD_ID, VNDR_DTL_ASND_ID)
/

ALTER TABLE OLE_AP_INV_T
    ADD CONSTRAINT OLE_AP_INV_TR6
    FOREIGN KEY (VNDR_SHP_PMT_TERM_CD)
    REFERENCES PUR_SHP_PMT_TERM_T (VNDR_SHP_PMT_TERM_CD)
/

ALTER TABLE OLE_AP_INV_T
    ADD CONSTRAINT OLE_AP_INV_TR7
    FOREIGN KEY (VNDR_PMT_TERMS_CD)
    REFERENCES PUR_PMT_TERM_TYP_T (VNDR_PMT_TERM_CD)
/

ALTER TABLE OLE_AP_INV_PO_ITM_T
    ADD CONSTRAINT OLE_AP_INV_PO_ITM_TR1
    FOREIGN KEY (INV_RQST_ID)
    REFERENCES OLE_AP_INV_T (INV_RQST_ID)
/

ALTER TABLE OLE_AP_INV_PO_ITM_T
    ADD CONSTRAINT OLE_AP_INV_PO_ITM_TR2
    FOREIGN KEY (ITM_TYP_CD)
    REFERENCES PUR_AP_ITM_TYP_T (ITM_TYP_CD)
/

ALTER TABLE OLE_AP_INV_PO_ITM_T
    ADD CONSTRAINT OLE_AP_INV_PO_ITM_TR3
    FOREIGN KEY (OLE_FRMT_ID)
    REFERENCES OLE_PUR_FRMT_T (OLE_FRMT_ID)
/

ALTER TABLE OLE_AP_INV_PO_ITM_T
    ADD CONSTRAINT OLE_AP_INV_PO_ITM_TR4
    FOREIGN KEY (OLE_REQ_RCPT_STATUS_ID)
    REFERENCES OLE_PUR_REQ_RCPT_STATUS_T (OLE_REQ_RCPT_STATUS_ID)
/

ALTER TABLE OLE_AP_INV_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_ACCT_TR1
    FOREIGN KEY (INV_PO_ITM_ID)
    REFERENCES OLE_AP_INV_PO_ITM_T (INV_PO_ITM_ID)
/

ALTER TABLE OLE_AP_INV_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE OLE_AP_INV_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_ACCT_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE OLE_AP_INV_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_ACCT_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE OLE_AP_INV_SUM_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_SUM_ACCT_TR1
    FOREIGN KEY (INV_RQST_ID)
    REFERENCES OLE_AP_INV_T (INV_RQST_ID)
/

ALTER TABLE OLE_AP_INV_SUM_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_SUM_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE OLE_AP_INV_SUM_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_SUM_ACCT_TR3
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE OLE_AP_INV_SUM_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_SUM_ACCT_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE OLE_AP_INV_SUM_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_SUM_ACCT_TR6
    FOREIGN KEY (CRDT_MEMO_ID)
    REFERENCES AP_CRDT_MEMO_T (CRDT_MEMO_ID)
/

ALTER TABLE OLE_AP_INV_ACCT_CHG_T
    ADD CONSTRAINT OLE_AP_INV_ACCT_CHG_TR2
    FOREIGN KEY (INV_PO_ITM_ID)
    REFERENCES OLE_AP_INV_PO_ITM_T (INV_PO_ITM_ID)
/

ALTER TABLE OLE_AP_INV_ACCT_CHG_T
    ADD CONSTRAINT OLE_AP_INV_ACCT_CHG_TR3
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE OLE_AP_INV_ACCT_CHG_T
    ADD CONSTRAINT OLE_AP_INV_ACCT_CHG_TR4
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE OLE_AP_INV_ACCT_CHG_T
    ADD CONSTRAINT OLE_AP_INV_ACCT_CHG_TR5
    FOREIGN KEY (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE OLE_AP_INV_ACCT_CHG_T
    ADD CONSTRAINT OLE_AP_INV_ACCT_CHG_TR6
    FOREIGN KEY (FDOC_POST_YR, FDOC_POST_PRD_CD)
    REFERENCES SH_ACCT_PERIOD_T (UNIV_FISCAL_YR, UNIV_FISCAL_PRD_CD)
/

ALTER TABLE OLE_AP_INV_ITM_NTE_T
    ADD CONSTRAINT OLE_INV_ITM_NTE_TR1
    FOREIGN KEY (INV_PO_ITM_ID)
    REFERENCES OLE_AP_INV_PO_ITM_T (INV_PO_ITM_ID)
/

ALTER TABLE OLE_COPY_T
    ADD CONSTRAINT OLE_COPY_T_REQ_CONS
    FOREIGN KEY (REQS_ITM_ID)
    REFERENCES PUR_REQS_ITM_T (REQS_ITM_ID)
/

ALTER TABLE OLE_COPY_T
    ADD CONSTRAINT OLE_COPY_T_PO_CONS
    FOREIGN KEY (FDOC_NBR, PO_ITM_ID)
    REFERENCES PUR_PO_ITM_T (FDOC_NBR, PO_ITM_ID)
/

ALTER TABLE OLE_COPY_T
    ADD CONSTRAINT OLE_COPY_T_RCVL_CONS
    FOREIGN KEY (RCVNG_LN_ITM_ID)
    REFERENCES PUR_RCVNG_LN_ITM_T (RCVNG_LN_ITM_ID)
/

ALTER TABLE OLE_COPY_T
    ADD CONSTRAINT OLE_COPY_T_RCVC_CONS
    FOREIGN KEY (RCVNG_COR_ITM_ID)
    REFERENCES PUR_RCVNG_COR_ITM_T (RCVNG_COR_ITM_ID)
/

ALTER TABLE OLE_PAID_COPY_T
    ADD CONSTRAINT OLE_PAID_COPY_TC0
    FOREIGN KEY (INV_PO_ITM_ID)
    REFERENCES OLE_AP_INV_PO_ITM_T (INV_PO_ITM_ID)
/

ALTER TABLE OLE_PAID_COPY_T
    ADD CONSTRAINT OLE_PAID_COPY_TC2
    FOREIGN KEY (PMT_RQST_ITM_ID)
    REFERENCES AP_PMT_RQST_ITM_T (PMT_RQST_ITM_ID)
/

ALTER TABLE OLE_AP_INV_OFFSET_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_OFF_ACCT_TR1
    FOREIGN KEY (INV_PO_ITM_ID)
    REFERENCES OLE_AP_INV_PO_ITM_T (INV_PO_ITM_ID)
/

ALTER TABLE OLE_AP_INV_OFFSET_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_OFF_ACCT_TR2
    FOREIGN KEY (FIN_COA_CD)
    REFERENCES CA_CHART_T (FIN_COA_CD)
/

ALTER TABLE OLE_AP_INV_OFFSET_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_OFF_ACCT_TR3
    FOREIGN KEY (FIN_COA_CD, OFF_ACCOUNT_NBR)
    REFERENCES CA_ACCOUNT_T (FIN_COA_CD, ACCOUNT_NBR)
/

ALTER TABLE OLE_AP_INV_OFFSET_ACCT_T
    ADD CONSTRAINT OLE_AP_INV_OFF_ACCT_TR4
    FOREIGN KEY (FIN_COA_CD, OFF_ACCOUNT_NBR, OFF_SUB_ACCT_NBR)
    REFERENCES CA_SUB_ACCT_T (FIN_COA_CD, ACCOUNT_NBR, SUB_ACCT_NBR)
/

ALTER TABLE OLE_PO_CLM_HIS_T
    ADD CONSTRAINT OLE_PO_CLM_HIS_T_REQ_CONS
    FOREIGN KEY (REQS_ITM_ID)
    REFERENCES PUR_REQS_ITM_T (REQS_ITM_ID)
/

ALTER TABLE OLE_PO_CLM_HIS_T
    ADD CONSTRAINT OLE_PO_CLM_HIS_PO_CONS
    FOREIGN KEY (FDOC_NBR, PO_ITM_ID)
    REFERENCES PUR_PO_ITM_T (FDOC_NBR, PO_ITM_ID)
/