• 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.oracle.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)
/