APPS.FII_AR_REVENUE_B_C dependencies on RA_CUSTOMER_TRX_ALL

Line 580: ra_customer_trx_all ct,

576: null) CHILD_ORDER_LINE_ID
577: FROM
578: fii_ar_revenue_id fpk,
579: ra_customer_trx_lines_all ctl,
580: ra_customer_trx_all ct,
581: ra_cust_trx_types_all ctt,
582: ra_cust_trx_line_gl_dist_all ctlgd,
583: gl_code_combinations glcc,
584: fii_gl_ccid_dimensions ccdim,

Line 863: ra_customer_trx_all ct,

859: fii_gl_ccid_dimensions ccdim,
860: fii_slg_assignments slga,
861: fii_source_ledger_groups fslg,
862: -- fii_fin_cat_type_assgns ffcta,
863: ra_customer_trx_all ct,
864: -- ra_customer_trx_lines_all ctl,
865: -- ra_customer_trx_lines_all ctl_parent,
866: -- oe_order_lines_all sl_child,
867: -- oe_order_headers_all sh,

Line 1167: ra_customer_trx_all ct,

1163: null) x_child_order_line_id,
1164: AC.Fin_Cat_Type_Code x_fin_cat_type_code
1165: from fii_ar_revenue_id fpk,
1166: ra_customer_trx_lines_all ctl,
1167: ra_customer_trx_all ct,
1168: ra_cust_trx_types_all ctt,
1169: ra_cust_trx_line_gl_dist_all ctlgd,
1170: ACCNT_CLASS AC,
1171: xla_distribution_links lnk,

Line 1778: from ra_customer_trx_all t,

1774: primary_key1)
1775: SELECT --+ ORDERED USE_NL(ADJ)
1776: 7,
1777: adj.adjustment_id
1778: from ra_customer_trx_all t,
1779: ar_adjustments_all adj,
1780: ( select distinct ledger_id
1781: from fii_slg_assignments slga,
1782: fii_source_ledger_groups fslg

Line 1856: FROM ra_customer_trx_all ct,

1852: primary_key1)
1853: SELECT
1854: 8,
1855: ctl.customer_trx_line_id
1856: FROM ra_customer_trx_all ct,
1857: ra_customer_trx_lines_all ctl,
1858: ( select distinct ledger_id
1859: from fii_slg_assignments slga,
1860: fii_source_ledger_groups fslg

Line 2876: ra_customer_trx_all trx

2872: NOLOGGING storage (initial 4K next 16K MAXEXTENTS UNLIMITED) as
2873: select
2874: wh.invoice_id invoice_id
2875: from '||g_fii_schema||'.fii_ar_revenue_sum_del1 wh,
2876: ra_customer_trx_all trx
2877: where wh.invoice_id = trx.customer_trx_id (+)
2878: AND trx.customer_trx_id IS NULL ';
2879:
2880: if g_debug_flag = 'Y' then

Line 3382: (select /*+ PARALLEL(a) */ * from ra_customer_trx_all a) ct,

3378: ael.code_combination_id,
3379: AC.Fin_Cat_Type_Code
3380: ) v1,
3381: (select /*+ PARALLEL(a) */ * from ra_customer_trx_lines_all a) ctl,
3382: (select /*+ PARALLEL(a) */ * from ra_customer_trx_all a) ct,
3383: --**bug 3437052: move sob 2 places down
3384: (select /*+ PARALLEL(a) */ * from gl_ledgers_public_v a) sob,
3385: (select /*+ PARALLEL(a) */ * from ra_cust_trx_types_all a) ctt,
3386: (select /*+ PARALLEL(a) */ * from hz_cust_accounts a) bill_acct ,