DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on OE_HOLD_SOURCES_ALL

Line 3767: FROM oe_hold_sources_all ohs,

3763: /* Modified for bug 7446647
3764: CURSOR check_cust_on_credit_hold
3765: IS
3766: SELECT prt.party_name
3767: FROM oe_hold_sources_all ohs,
3768: HZ_PARTIES prt,
3769: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,
3770: okc_k_headers_all_b rl
3771: WHERE ohs.hold_entity_code = 'C'

Line 3796: FROM oe_hold_sources_all ohs,

3792: 2,
3793: 'COMPLIANCE',
3794: 3,
3795: 4) credit_typ
3796: FROM oe_hold_sources_all ohs,
3797: oe_hold_definitions ohd,
3798: HZ_PARTIES prt,
3799: HZ_PARTY_SITES PS,
3800: HZ_CUST_ACCT_SITES_ALL CA,

Line 3828: FROM oe_hold_sources_all ohs,

3824: 2,
3825: 'COMPLIANCE',
3826: 3,
3827: 4) credit_typ
3828: FROM oe_hold_sources_all ohs,
3829: oe_hold_definitions ohd,
3830: HZ_PARTIES prt,
3831: HZ_PARTY_SITES PS,
3832: HZ_CUST_ACCT_SITES_ALL CA,