DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on MO_GLOB_ORG_ACCESS_TMP

Line 6329: mo_glob_org_access_tmp. This is as per the appsperf team suggestion*/

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*/
6333: /*added nl_aj hint as per appsperf team suggestion*/

Line 6356: mo_glob_org_access_tmp oa,

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
6360: where osb.ste_code <> 'HOLD'