APPS.FII_AR_REVENUE_B_C dependencies on HZ_CUST_ACCOUNTS

Line 590: hz_cust_accounts bill_acct,

586: fii_source_ledger_groups fslg,
587: -- fii_fin_cat_type_assgns ffcta,
588: ra_customer_trx_lines_all ctl_parent,
589: gl_ledgers_public_v sob,
590: hz_cust_accounts bill_acct,
591: oe_order_lines_all sl_child,
592: oe_order_lines_all sl_parent,
593: oe_order_headers_all sh,
594: ACCNT_CLASS AC,

Line 870: hz_cust_accounts bill_acct,

866: -- oe_order_lines_all sl_child,
867: -- oe_order_headers_all sh,
868: -- oe_order_lines_all sl_parent,
869: gl_ledgers_public_v sob,
870: hz_cust_accounts bill_acct,
871: ACCNT_CLASS AC,
872: xla_ae_headers aeh,
873: xla_ae_lines ael,
874: xla_distribution_links lnk

Line 1222: hz_cust_accounts bill_acct,

1218: ) X,
1219: gl_ledgers_public_v sob,
1220: gl_code_combinations glcc,
1221: ra_customer_trx_lines_all ctl_parent,
1222: hz_cust_accounts bill_acct,
1223: oe_order_lines_all sl_child,
1224: oe_order_lines_all sl_parent,
1225: oe_order_headers_all sh
1226: WHERE Y.y_code_combination_id = X.x_code_combination_id

Line 3386: (select /*+ PARALLEL(a) */ * from hz_cust_accounts a) bill_acct ,

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 ,
3387: (select /*+ PARALLEL(a) */ * from ra_customer_trx_lines_all a) ctl_parent,
3388: (select /*+ PARALLEL(a) */ * from oe_order_lines_all a) sl_child,
3389: (select /*+ PARALLEL(a) */ * from oe_order_headers_all a) sh,
3390: (select /*+ PARALLEL(a) */ * from oe_order_lines_all a) sl_parent