DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on RCV_ACCOUNTING_EVENTS

Line 3465: rcv_accounting_events rae,

3461: /* End OPM Financials */
3462: UNION
3463: SELECT DISTINCT pod.po_distribution_id
3464: FROM po_distributions_all pod,
3465: rcv_accounting_events rae,
3466: rcv_receiving_sub_ledger rrs
3467: WHERE pod.accrual_account_id is NOT NULL
3468: AND pod.accrue_on_receipt_flag = 'Y'
3469: AND rae.transaction_date between p_from_date AND p_to_date

Line 3657: rcv_accounting_events rae,

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

Line 3680: AND xte.entity_code = 'RCV_ACCOUNTING_EVENTS'

3676: AND xah.ae_header_id = xal.ae_header_id
3677: AND xah.gl_transfer_status_code = 'Y'
3678: AND xte.entity_id = xah.entity_id
3679: AND xte.ledger_id = fsp.set_of_books_id
3680: AND xte.entity_code = 'RCV_ACCOUNTING_EVENTS'
3681: AND xdl.ae_header_id = xal.ae_header_id
3682: AND xdl.ae_line_num = xal.ae_line_num
3683: AND xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
3684: AND rct.transaction_id = NVL(xte.source_id_int_1,(-99))