APPS.CST_ACCRUAL_LOAD dependencies on RCV_RECEIVING_SUB_LEDGER

Line 1156: rcv_receiving_sub_ledger rrs,

1152: pawo.program_id,
1153: pawo.program_update_date
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

Line 1177: AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'

1173: AND ABS(NVL(rrs.accounted_dr,rrs.accounted_cr)) = ABS(pawo.transaction_amount)
1174: AND ((ABS(pawo.transaction_quantity) = ABS(rrs.source_doc_quantity))
1175: OR pawo.transaction_quantity is NULL
1176: )
1177: AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
1178: AND xld.source_distribution_id_num_1 = rrs.rcv_sub_ledger_id
1179: AND xld.application_id = 707;
1180:
1181: debug(' Done upgrading Receiving data');

Line 2051: rcv_receiving_sub_ledger rrs,

2047: cwo.program_update_date
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

Line 2067: AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'

2063: AND ca.operating_unit_id = p_operating_unit
2064: AND rrs.code_combination_id = ca.accrual_account_id
2065: --}
2066: AND rt.transaction_date BETWEEN p_upg_from_date AND p_upg_to_date
2067: AND xld.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
2068: AND xld.source_distribution_id_num_1 = rrs.rcv_sub_ledger_id
2069: AND xld.application_id = 707;
2070:
2071: debug(' Done Updating the write off details for PO RCV' );

Line 3136: rcv_receiving_sub_ledger rrs

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

Line 3162: rcv_receiving_sub_ledger rrs

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

Line 3327: rcv_receiving_sub_ledger rrs,

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

Line 3352: AND xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'

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))
3354: AND rct.source_document_code <> 'REQ'
3355: AND rct.transaction_date <= p_to_date /* Added for bug 6913157 */
3356: AND rct.transaction_id = rrs.rcv_transaction_id