[Home] [Help]
1129: FROM
1130: po_accrual_write_offs_all pawo,
1131: rcv_receiving_sub_ledger rrs,
1132: xla_distribution_links xld, --BUG#7275286
1133: rcv_transactions rt,
1134: po_headers_all poh
1135: ,cst_accrual_accounts ca --BUG#7528609
1136: ,PO_distributions_all pod
1137: WHERE pawo.org_id = p_operating_unit
2049: FROM cst_write_offs cwo,
2050: po_accrual_write_offs_all pawo,
2051: po_lookup_codes plc,
2052: rcv_receiving_sub_ledger rrs,
2053: rcv_transactions rt,
2054: xla_distribution_links xld,
2055: cst_accrual_accounts ca --BUG#7528609
2056: WHERE pawo.org_id = p_operating_unit
2057: AND pawo.transaction_source_code = 'PO'
3434: CURSOR c_po_dists is
3435: SELECT /*+ LEADING(rt) USE_NL(rrs,pod) */
3436: DISTINCT pod.po_distribution_id
3437: FROM po_distributions_all pod,
3438: rcv_transactions rt,
3439: rcv_receiving_sub_ledger rrs
3440: WHERE pod.accrual_account_id is NOT NULL
3441: AND pod.accrue_on_receipt_flag = 'Y'
3442: AND rt.transaction_date between p_from_date AND p_to_date
3447: UNION
3448: SELECT /*+ LEADING(rt) USE_NL(grat,pod) */
3449: DISTINCT pod.po_distribution_id
3450: FROM po_distributions_all pod,
3451: rcv_transactions rt,
3452: gmf_rcv_accounting_txns grat
3453: WHERE pod.accrual_account_id is NOT NULL
3454: AND pod.accrue_on_receipt_flag = 'Y'
3455: /*Bug 12346836 - Replaced rt.transaction_date with grat.transaction_date here*/
3652: l_build_id,
3653: l_request_id,
3654: xal.ae_header_id,
3655: xal.ae_line_num
3656: FROM rcv_transactions rct,
3657: rcv_accounting_events rae,
3658: rcv_receiving_sub_ledger rrs,
3659: xla_ae_headers xah,
3660: xla_ae_lines xal,
3772: l_build_id,
3773: l_request_id,
3774: xal.ae_header_id,
3775: xal.ae_line_num
3776: FROM rcv_transactions rct,
3777: gmf_rcv_accounting_txns grat,
3778: gmf_xla_extract_headers geh,
3779: gmf_xla_extract_lines gel,
3780: xla_ae_headers xah,