APPS.AR_PURGE dependencies on AR_CASH_RECEIPT_HISTORY

Line 1069: ar_cash_receipt_history crh,

1065: hz_parties cust_party,
1066: iby_trxn_extensions_v iby,
1067: ar_receivable_applications ra,
1068: ar_receivable_applications ra1, --bug1199027
1069: ar_cash_receipt_history crh,
1070: ar_cash_receipt_history crh_batch,
1071: ar_cash_receipt_history crh_remit,
1072: ar_cash_receipts cr
1073: WHERE lu1.lookup_code (+) = cr.reversal_category

Line 1070: ar_cash_receipt_history crh_batch,

1066: iby_trxn_extensions_v iby,
1067: ar_receivable_applications ra,
1068: ar_receivable_applications ra1, --bug1199027
1069: ar_cash_receipt_history crh,
1070: ar_cash_receipt_history crh_batch,
1071: ar_cash_receipt_history crh_remit,
1072: ar_cash_receipts cr
1073: WHERE lu1.lookup_code (+) = cr.reversal_category
1074: AND lu1.lookup_type (+) = 'REVERSAL_CATEGORY_TYPE'

Line 1071: ar_cash_receipt_history crh_remit,

1067: ar_receivable_applications ra,
1068: ar_receivable_applications ra1, --bug1199027
1069: ar_cash_receipt_history crh,
1070: ar_cash_receipt_history crh_batch,
1071: ar_cash_receipt_history crh_remit,
1072: ar_cash_receipts cr
1073: WHERE lu1.lookup_code (+) = cr.reversal_category
1074: AND lu1.lookup_type (+) = 'REVERSAL_CATEGORY_TYPE'
1075: AND lu2.lookup_code (+) = cr.reversal_reason_code

Line 1102: from ar_cash_receipt_history crh1

1098: /* get remittance batch */
1099: AND crh_remit.batch_id = batch_remit.batch_id(+)
1100: AND nvl(crh_remit.cash_receipt_history_id, -99) in
1101: ( SELECT nvl( min(crh1.cash_receipt_history_id), -99 )
1102: from ar_cash_receipt_history crh1
1103: where crh1.cash_receipt_id = cr.cash_receipt_id
1104: and crh1.status = 'REMITTED' )
1105: AND crh_remit.status (+) = 'REMITTED'
1106: AND crh_remit.cash_receipt_id(+) = cr.cash_receipt_id

Line 2156: ar_cash_receipt_history crh,

2152: to_number(null), /* expiration_days */
2153: '' /* override_auto_accounting_flag */
2154: FROM
2155: ar_vat_tax vt,
2156: ar_cash_receipt_history crh,
2157: ar_cash_receipts cr ,
2158: ar_receivable_applications ra
2159: WHERE crh.cash_receipt_id = cr.cash_receipt_id
2160: and nvl(crh.current_record_flag, 'N') = 'Y'

Line 3865: ar_cash_receipt_history crh

3861: records into the following stmts */
3862: cursor dist_crh_cur is
3863: select 'Found' record_found
3864: FROM ar_distributions dist,
3865: ar_cash_receipt_history crh
3866: where crh.cash_receipt_history_id = dist.source_id (+)
3867: AND crh.cash_receipt_id = p_entity_id
3868: FOR UPDATE OF crh.cash_receipt_id,
3869: dist.source_id NOWAIT;

Line 3898: ar_cash_receipt_history crh,

3894: SELECT 'Found' record_found
3895: FROM ar_distributions dist,
3896: ar_payment_schedules ps,
3897: ar_receivable_applications ra,
3898: ar_cash_receipt_history crh,
3899: ar_cash_receipts cr
3900: WHERE cr.cash_receipt_id = p_entity_id
3901: AND cr.cash_receipt_id = crh.cash_receipt_id
3902: AND cr.cash_receipt_id = ra.cash_receipt_id (+)

Line 4009: FROM ar_cash_receipt_history

4005: l_unpurgeable_histories NUMBER;
4006: BEGIN
4007: SELECT COUNT(*)
4008: INTO l_unpurgeable_histories
4009: FROM ar_cash_receipt_history
4010: WHERE cash_receipt_id = p_entity_id
4011: AND
4012: (
4013: posting_control_id = -3 OR

Line 4024: FROM ar_cash_receipt_history

4020: END IF;
4021: -- 5715943
4022: SELECT COUNT(*)
4023: INTO l_unpurgeable_histories
4024: FROM ar_cash_receipt_history
4025: WHERE cash_receipt_id = p_entity_id
4026: AND current_record_flag = 'Y'
4027: AND
4028: (

Line 4072: FROM ar_cash_receipt_history crh,

4068: l_statement_reconciliation NUMBER;
4069: BEGIN
4070: SELECT COUNT(*)
4071: INTO l_statement_reconciliation
4072: FROM ar_cash_receipt_history crh,
4073: ce_statement_reconciliations sr
4074: WHERE cash_receipt_id = p_entity_id
4075: AND crh.cash_receipt_history_id = sr.reference_id
4076: AND sr.reference_type = 'RECEIPT'

Line 4109: FROM ar_cash_receipt_history

4105: CURSOR cur_batch_id(l_receipt_id NUMBER) IS
4106: SELECT bat.batch_id
4107: FROM ar_batches bat,
4108: (SELECT distinct batch_id
4109: FROM ar_cash_receipt_history
4110: WHERE cash_receipt_id = l_receipt_id) crh
4111: WHERE crh.batch_id = bat.batch_id
4112: FOR UPDATE OF bat.batch_id NOWAIT ;
4113: --

Line 4117: ar_cash_receipt_history crh

4113: --
4114: CURSOR cur_trans_id(l_receipt_id NUMBER) IS
4115: SELECT bat.transmission_request_id
4116: FROM ar_batches bat,
4117: ar_cash_receipt_history crh
4118: WHERE crh.cash_receipt_id = l_receipt_id
4119: AND crh.batch_id = bat.batch_id
4120: AND crh.first_posted_record_flag = 'Y';
4121:

Line 4145: FROM ar_cash_receipt_history

4141: DELETE FROM ar_distributions
4142: WHERE source_id in
4143: (
4144: SELECT cash_receipt_history_id
4145: FROM ar_cash_receipt_history
4146: WHERE cash_receipt_id = p_entity_id
4147: )
4148: AND source_table = 'CRH'
4149: RETURNING line_id

Line 4166: -- ar_cash_receipt_history rather

4162:
4163:
4164: --
4165: -- Bug 2021718: call the entity handler for
4166: -- ar_cash_receipt_history rather
4167: -- then doing the delete in this package.
4168: -- DELETE FROM ar_cash_receipt_history
4169: -- WHERE cash_receipt_id = p_entity_id;
4170:

Line 4168: -- DELETE FROM ar_cash_receipt_history

4164: --
4165: -- Bug 2021718: call the entity handler for
4166: -- ar_cash_receipt_history rather
4167: -- then doing the delete in this package.
4168: -- DELETE FROM ar_cash_receipt_history
4169: -- WHERE cash_receipt_id = p_entity_id;
4170:
4171: arp_cr_history_pkg.delete_p_cr(p_entity_id);
4172:

Line 4183: FROM ar_cash_receipt_history h

4179: FORALL i IN l_batch_id.FIRST..l_batch_id.LAST
4180: DELETE FROM ar_batches
4181: WHERE batch_id = l_batch_id(i)
4182: AND NOT EXISTS ( SELECT 'x'
4183: FROM ar_cash_receipt_history h
4184: WHERE h.batch_id = l_batch_id(i) )
4185: RETURNING batch_id
4186: BULK COLLECT INTO l_ar_batch_key_value_list;
4187: