DBA Data[Home] [Help]

APPS.FII_AR_REVENUE_B_C dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 579: ra_customer_trx_lines_all ctl,

575: decode(ctl.interface_line_context, 'ORDER ENTRY',ctl.interface_line_attribute6,
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,

Line 588: ra_customer_trx_lines_all ctl_parent,

584: fii_gl_ccid_dimensions ccdim,
585: fii_slg_assignments slga,
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,

Line 864: -- ra_customer_trx_lines_all ctl,

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,
868: -- oe_order_lines_all sl_parent,

Line 865: -- ra_customer_trx_lines_all ctl_parent,

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,
868: -- oe_order_lines_all sl_parent,
869: gl_ledgers_public_v sob,

Line 1166: ra_customer_trx_lines_all ctl,

1162: decode(ctl.interface_line_context, 'ORDER ENTRY',ctl.interface_line_attribute6,
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,

Line 1221: ra_customer_trx_lines_all ctl_parent,

1217: AC.Fin_Cat_Type_Code
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

Line 1846: -- For ra_customer_trx_lines_all.

1842:
1843: /* ELSIF (p_type = 'AR INV') THEN
1844:
1845: -- -----------------------------------------
1846: -- For ra_customer_trx_lines_all.
1847: -- -----------------------------------------
1848:
1849: l_stmt := '
1850: INSERT INTO FII_AR_REVENUE_ID (

Line 1857: ra_customer_trx_lines_all ctl,

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
1861: where slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 1872: FROM ra_customer_trx_lines_all ct,

1868: UNION
1869: SELECT
1870: 8,
1871: ct.customer_trx_line_id
1872: FROM ra_customer_trx_lines_all ct,
1873: ( select distinct ledger_id
1874: from fii_slg_assignments slga,
1875: fii_source_ledger_groups fslg
1876: where slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 2149: from ra_customer_trx_lines_all line,

2145: where y.org_id = b.org_id
2146: union all
2147: select /*+ PARALLEL(line) PARALLEL(rule) */
2148: line.CUSTOMER_TRX_LINE_ID lid
2149: from ra_customer_trx_lines_all line,
2150: RA_RULES rule
2151: where line.ACCOUNTING_RULE_ID = rule.RULE_ID
2152: and rule.DEFERRED_REVENUE_FLAG = ''Y''' ||l_stmt2|| '
2153: ) z

Line 3381: (select /*+ PARALLEL(a) */ * from ra_customer_trx_lines_all a) ctl,

3377: trunc(aeh.accounting_date),
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,

Line 3387: (select /*+ PARALLEL(a) */ * from ra_customer_trx_lines_all a) ctl_parent,

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
3391: WHERE ccdim.code_combination_id = gcc.code_combination_id