DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on RCV_ACCOUNTING_EVENTS

Line 3161: rcv_accounting_events rae,

3157: /* End OPM Financials */
3158: UNION
3159: SELECT DISTINCT pod.po_distribution_id
3160: FROM po_distributions_all pod,
3161: rcv_accounting_events rae,
3162: rcv_receiving_sub_ledger rrs
3163: WHERE pod.accrual_account_id is NOT NULL
3164: AND pod.accrue_on_receipt_flag = 'Y'
3165: AND rae.transaction_date between p_from_date AND p_to_date

Line 3326: rcv_accounting_events rae,

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,
3330: xla_transaction_entities_upg xte,

Line 3349: AND xte.entity_code = 'RCV_ACCOUNTING_EVENTS'

3345: AND xah.ae_header_id = xal.ae_header_id
3346: AND xah.gl_transfer_status_code = 'Y'
3347: AND xte.entity_id = xah.entity_id
3348: AND xte.ledger_id = fsp.set_of_books_id
3349: AND xte.entity_code = 'RCV_ACCOUNTING_EVENTS'
3350: AND xdl.ae_header_id = xah.ae_header_id
3351: AND xdl.ae_line_num = xal.ae_line_num
3352: AND xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
3353: AND rct.transaction_id = NVL(xte.source_id_int_1,(-99))