eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AR_REVENUE_B_C dependencies on OE_ORDER_LINES_ALL

Line 591: oe_order_lines_all sl_child,

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,
595: xla_ae_headers aeh,

Line 592: oe_order_lines_all sl_parent,

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,
595: xla_ae_headers aeh,
596: xla_ae_lines ael,

Line 866: -- oe_order_lines_all sl_child,

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,
870: hz_cust_accounts bill_acct,

Line 868: -- oe_order_lines_all sl_parent,

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,
870: hz_cust_accounts bill_acct,
871: ACCNT_CLASS AC,
872: xla_ae_headers aeh,

Line 1223: oe_order_lines_all sl_child,

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
1227: AND Y.y_code_combination_id = glcc.code_combination_id

Line 1224: oe_order_lines_all sl_parent,

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
1227: AND Y.y_code_combination_id = glcc.code_combination_id
1228: AND Y.y_ledger_id = X.x_set_of_books_id

Line 3388: (select /+ PARALLEL(a) / * from oe_order_lines_all a) sl_child,

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
3392: AND slga.chart_of_accounts_id = ccdim.chart_of_accounts_id

Line 3390: (select /+ PARALLEL(a) / * from oe_order_lines_all a) sl_parent

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
3392: AND slga.chart_of_accounts_id = ccdim.chart_of_accounts_id
3393: AND ( slga.bal_seg_value_id = ccdim.company_id
3394: OR slga.bal_seg_value_id = -1 )