[Home] [Help]
1154: FROM
1155: po_accrual_write_offs_all pawo,
1156: rcv_receiving_sub_ledger rrs,
1157: xla_distribution_links xld, --BUG#7275286
1158: rcv_transactions rt,
1159: po_headers_all poh
1160: ,cst_accrual_accounts ca --BUG#7528609
1161: WHERE pawo.org_id = p_operating_unit
1162: AND pawo.transaction_source_code = 'PO'
2048: FROM cst_write_offs cwo,
2049: po_accrual_write_offs_all pawo,
2050: po_lookup_codes plc,
2051: rcv_receiving_sub_ledger rrs,
2052: rcv_transactions rt,
2053: xla_distribution_links xld,
2054: cst_accrual_accounts ca --BUG#7528609
2055: WHERE pawo.org_id = p_operating_unit
2056: AND pawo.transaction_source_code = 'PO'
3131: CURSOR c_po_dists is
3132: SELECT /*+ LEADING(rt) USE_NL(rrs,pod) */
3133: DISTINCT pod.po_distribution_id
3134: FROM po_distributions_all pod,
3135: rcv_transactions rt,
3136: rcv_receiving_sub_ledger rrs
3137: WHERE pod.accrual_account_id is NOT NULL
3138: AND pod.accrue_on_receipt_flag = 'Y'
3139: AND rt.transaction_date between p_from_date AND p_to_date
3144: UNION
3145: SELECT /*+ LEADING(rt) USE_NL(grat,pod) */
3146: DISTINCT pod.po_distribution_id
3147: FROM po_distributions_all pod,
3148: rcv_transactions rt,
3149: gmf_rcv_accounting_txns grat
3150: WHERE pod.accrual_account_id is NOT NULL
3151: AND pod.accrue_on_receipt_flag = 'Y'
3152: AND rt.transaction_date between p_from_date AND p_to_date
3321: l_build_id,
3322: l_request_id,
3323: xal.ae_header_id,
3324: xal.ae_line_num
3325: FROM rcv_transactions rct,
3326: rcv_accounting_events rae,
3327: rcv_receiving_sub_ledger rrs,
3328: xla_ae_headers xah,
3329: xla_ae_lines xal,
3439: l_build_id,
3440: l_request_id,
3441: xal.ae_header_id,
3442: xal.ae_line_num
3443: FROM rcv_transactions rct,
3444: gmf_rcv_accounting_txns grat,
3445: gmf_xla_extract_headers geh,
3446: gmf_xla_extract_lines gel,
3447: xla_ae_headers xah,