DBA Data[Home] [Help]

APPS.OKS_ARFETCH_PUB dependencies on STANDARD

Line 137: --the MOAC predicate and others are with the _ALL table(this is as per MOAC standard

133: --So Do not change the order of the from clause and the hints.
134:
135: --This FP fix is slightly different than the 11.5.10 fix due to the
136: --MOAC functionality. Among all the MOAC enabled tables only one is with
137: --the MOAC predicate and others are with the _ALL table(this is as per MOAC standard
138:
139: Cursor get_fetch_records_csr is
140: SELECT /*+ leading(BTN,BTXNL,RALINES,HDR,RAHDR) use_nl(BTXNL,HDR,RAHDR) use_hash(RATYPES) swap_join_inputs(RATYPES) parallel(RALINES) */
141: btn.id txn_id