DBA Data[Home] [Help]

APPS.OKS_CCMIGRATE_PVT dependencies on OKC_STATUSES_V

Line 1979: okc_statuses_v st

1975: AND b.cust_account_id = cust_acct_id) party_name
1976: FROM oks_rule_error ore,
1977: oks_k_headers_b okh,
1978: okc_k_headers_all_b kh,
1979: okc_statuses_v st
1980: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
1981: AND ore.chr_id = kh.ID
1982: AND ore.cle_id IS NULL
1983: AND kh.ID = okh.chr_id

Line 2004: okc_statuses_v st

2000: WHERE a.party_id = b.party_id
2001: AND b.cust_account_id = cust_acct_id) party_name
2002: FROM oks_rule_error ore,
2003: okc_k_headers_all_bh kh,
2004: okc_statuses_v st
2005: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
2006: AND ore.chr_id = kh.ID
2007: AND ore.cle_id IS NULL
2008: AND ore.major_version IS NOT NULL

Line 2040: okc_statuses_v st,

2036: AND ROWNUM < 2) service_name
2037:
2038: FROM oks_rule_error ore,
2039: okc_k_headers_all_b kh,
2040: okc_statuses_v st,
2041: oks_k_lines_b ls,
2042: okc_k_lines_b lc,
2043: okc_k_items it
2044: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'

Line 2083: okc_statuses_v st,

2079: AND ROWNUM < 2) service_name
2080:
2081: FROM oks_rule_error ore,
2082: okc_k_headers_all_b kh,
2083: okc_statuses_v st,
2084: okc_k_lines_bh lc,
2085: okc_k_items it
2086: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
2087: AND ore.cle_id = lc.id