APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on OE_ORDER_HEADERS_ALL

Line 473: ' FROM OE_ORDER_HEADERS_ALL h,'||

469: ' l.sold_to_org_id SOLD_TO_ORG_ID,'||
470: ' l.service_reference_line_id SERVICE_REFERENCE_LINE_ID,'||
471: ' nvl(opa.charge_adjamt,0)*l.ordered_quantity + nvl(opa.charge_operand,0) FREIGHT_CHARGE,'||
472: ' opa.cost FREIGHT_COST'||
473: ' FROM OE_ORDER_HEADERS_ALL h,'||
474: ' OE_ORDER_LINES_ALL l,'||
475: ' AR_SYSTEM_PARAMETERS_ALL aspa,'||
476: ' GL_SETS_OF_BOOKS gsb,'||
477: ' HR_ORGANIZATION_INFORMATION hoi,'||

Line 818: OE_ORDER_HEADERS_ALL h,

814: and p.charge_type_code in ('FTEPRICE', 'FTECHARGE')
815: group by p.line_id) opa,
816: (select /*+ no_merge cardinality (ilog, 1000)*/ distinct line_id, header_id from isc_dbi_change_log ilog) log,
817: oe_order_lines_all l,
818: OE_ORDER_HEADERS_ALL h,
819: AR_SYSTEM_PARAMETERS_ALL aspa,
820: GL_SETS_OF_BOOKS gsb,
821: HR_ORGANIZATION_INFORMATION hoi,
822: OE_SYS_PARAMETERS_ALL ospa,

Line 930: -- OE_ORDER_HEADERS_ALL h,

926: -- pl.component_number||decode(pl.service_number,'','','.')||
927: -- pl.service_number LINE_NUMBER
928: -- FROM (SELECT distinct top_model_line_id FROM isc_tmp_book_sum2) log,
929: -- oe_order_lines_all pl,
930: -- OE_ORDER_HEADERS_ALL h,
931: -- AR_SYSTEM_PARAMETERS_ALL aspa,
932: -- GL_SETS_OF_BOOKS gsb,
933: -- HR_ORGANIZATION_INFORMATION hoi,
934: -- OE_SYSTEM_PARAMETERS_ALL ospa,