DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on OKC_K_HEADERS_ALL_B

Line 6328: If p_access_mode = 'M' then make a direct join of okc_k_headers_all_b with

6324: End if;
6325:
6326: /*Added for bug:10191601*/
6327: /*p_access_mode = 'M' for multi-org, 'S' for Single org.
6328: If p_access_mode = 'M' then make a direct join of okc_k_headers_all_b with
6329: mo_glob_org_access_tmp. This is as per the appsperf team suggestion*/
6330:
6331: IF Nvl(p_access_mode,'X') = 'M' THEN
6332: /*removed the parallel hint and added NO_PUSH_PRED(lvl) as per appsperf team suggestion*/

Line 6355: okc_k_headers_all_b hdr,

6351: from okc_assents a
6352: where a.opn_code = 'INVOICE'
6353: and a.allowed_yn = 'Y'
6354: ) as1,
6355: okc_k_headers_all_b hdr,
6356: mo_glob_org_access_tmp oa,
6357: (
6358: Select distinct code
6359: from okc_statuses_b osb