DBA Data[Home] [Help]

APPS.ARP_ACCT_EVENT_PKG dependencies on AR_DISTRIBUTIONS_ALL

Line 665: FROM ar_distributions_all ard,

661: p_end_date IN DATE,
662: p_org_id IN NUMBER)
663: IS
664: SELECT adj.adjustment_id
665: FROM ar_distributions_all ard,
666: ar_adjustments_all adj
667: WHERE ard.source_table = 'ADJ'
668: AND ard.source_id = adj.adjustment_id
669: AND adj.gl_date BETWEEN p_start_date AND p_end_date

Line 679: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

675: FROM xla_distribution_links lk,
676: xla_ae_lines ae
677: WHERE ard.line_id = lk.source_distribution_id_num_1
678: AND lk.application_id = 222
679: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
680: AND ae.application_id = 222
681: AND lk.ae_header_id = ae.ae_header_id
682: AND lk.ae_line_num = ae.ae_line_num);
683: l_adj_id NUMBER;

Line 852: FROM ar_distributions_all ard,

848: p_org_id IN NUMBER,
849: p_type IN VARCHAR2)
850: IS
851: SELECT crh.cash_receipt_id
852: FROM ar_distributions_all ard,
853: ar_cash_receipt_history_all crh,
854: ar_cash_receipts_all cr
855: WHERE ard.source_table = 'CRH'
856: AND ard.source_id = crh.cash_receipt_history_id

Line 870: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

866: FROM xla_distribution_links lk,
867: xla_ae_lines ae
868: WHERE ard.line_id = lk.source_distribution_id_num_1
869: AND lk.application_id = 222
870: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
871: AND ae.application_id = 222
872: AND lk.ae_header_id = ae.ae_header_id
873: AND lk.ae_line_num = ae.ae_line_num);
874: l_cr_id NUMBER;

Line 948: FROM ar_distributions_all ard,

944: p_org_id IN NUMBER,
945: p_type IN VARCHAR2)
946: IS
947: SELECT ra.receivable_application_id
948: FROM ar_distributions_all ard,
949: ar_receivable_applications_all ra
950: WHERE ard.source_table = 'RA'
951: AND ra.status = 'APP'
952: AND ard.source_id = ra.receivable_application_id

Line 966: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

962: FROM xla_distribution_links lk,
963: xla_ae_lines ae
964: WHERE ard.line_id = lk.source_distribution_id_num_1
965: AND lk.application_id = 222
966: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
967: AND ae.application_id = 222
968: AND lk.ae_header_id = ae.ae_header_id
969: AND lk.ae_line_num = ae.ae_line_num);
970: l_ra_id NUMBER;

Line 1040: FROM ar_distributions_all ard,

1036: p_end_date IN DATE,
1037: p_org_id IN NUMBER)
1038: IS
1039: SELECT th.customer_trx_id
1040: FROM ar_distributions_all ard,
1041: ar_transaction_history_all th
1042: WHERE ard.source_table = 'TH'
1043: AND ard.source_id = th.transaction_history_id
1044: AND th.gl_date BETWEEN p_start_date AND p_end_date

Line 1053: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1049: FROM xla_distribution_links lk,
1050: xla_ae_lines ae
1051: WHERE ard.line_id = lk.source_distribution_id_num_1
1052: AND lk.application_id = 222
1053: AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1054: AND ae.application_id = 222
1055: AND lk.ae_header_id = ae.ae_header_id
1056: AND lk.ae_line_num = ae.ae_line_num);
1057: l_trx_id NUMBER;