APPS.CST_ACCRUAL_LOAD dependencies on RCV_RECEIVING_SUB_LEDGER

Line 1131: rcv_receiving_sub_ledger rrs,

1127: pawo.program_id,
1128: pawo.program_update_date
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

Line 1154: AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'

1150: --BUG#8666698: round precision limited to 20 in 11i po_accrual_reconciliation_temo
1151: AND ((ABS(ROUND(pawo.transaction_quantity,20)) = ABS(ROUND(rrs.source_doc_quantity,20)))
1152: OR pawo.transaction_quantity is NULL
1153: )
1154: AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
1155: AND xld.source_distribution_id_num_1 = rrs.rcv_sub_ledger_id
1156: AND xld.application_id = 707
1157: and pod.po_distribution_id =rrs.reference3
1158: and rrs.reference3 = pawo.po_distribution_id;

Line 2052: rcv_receiving_sub_ledger rrs,

2048: --}
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

Line 2068: AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'

2064: AND ca.operating_unit_id = p_operating_unit
2065: AND rrs.code_combination_id = ca.accrual_account_id
2066: --}
2067: AND rt.transaction_date BETWEEN p_upg_from_date AND p_upg_to_date
2068: AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
2069: AND xld.source_distribution_id_num_1 = rrs.rcv_sub_ledger_id
2070: AND cwo.po_distribution_id = rrs.reference3 --BUG#10085698
2071: AND xld.application_id = 707;
2072:

Line 3439: rcv_receiving_sub_ledger rrs

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
3443: AND pod.org_id = p_operating_unit

Line 3466: rcv_receiving_sub_ledger rrs

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
3470: AND pod.org_id = p_operating_unit

Line 3621: SELECT /*+ Leading(POD,POL,POH,RRS,XDL) INDEX(RRS RCV_RECEIVING_SUB_LEDGER_N2)*/

3617: Request_id,
3618: Ae_header_id,
3619: Ae_line_num
3620: )
3621: SELECT /*+ Leading(POD,POL,POH,RRS,XDL) INDEX(RRS RCV_RECEIVING_SUB_LEDGER_N2)*/
3622: rrs.transaction_date,
3623: ROUND((NVL(xal.accounted_dr,0) - NVL(xal.accounted_cr,0))
3624: / p_round_unit) * p_round_unit,
3625: ROUND((NVL(xal.entered_dr,0) - NVL(xal.entered_cr,0))

Line 3658: rcv_receiving_sub_ledger rrs,

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,
3662: xla_distribution_links xdl,

Line 3683: AND xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'

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))
3685: AND rct.source_document_code <> 'REQ'
3686: AND rct.transaction_date <= p_to_date /* Added for bug 6913157 */
3687: AND rrs.transaction_date <= p_to_date /* Bug# 12751777 Added to prevent future reto adj txns */