APPS.FII_AR_REVENUE_B_C dependencies on OE_ORDER_HEADERS_ALL

Line 593: oe_order_headers_all sh,

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,
597: xla_distribution_links lnk

Line 867: -- oe_order_headers_all sh,

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,
871: ACCNT_CLASS AC,

Line 1225: oe_order_headers_all sh

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
1229: AND ctl_parent.customer_trx_line_id = nvl(X.x_prev_customer_trx_line_id,X.x_customer_trx_line_id)

Line 3389: (select /*+ PARALLEL(a) */ * from oe_order_headers_all a) sh,

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
3393: AND ( slga.bal_seg_value_id = ccdim.company_id