[Home] [Help]
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,'||
478: ' OE_SYS_PARAMETERS_ALL ospa,'||
689: INSERT INTO isc_tmp_book_sum2(pk1, view_type)
690: SELECT distinct line_id, -1
691: FROM isc_dbi_change_log log
692: WHERE NOT EXISTS (select '1'
693: from oe_order_lines_all l
694: where l.line_id = log.line_id);
695: l_delete_count := sql%rowcount;
696:
697: FII_UTIL.Stop_Timer;
813: and p.line_id is not null
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,
925: -- decode(pl.component_number,'','','.'),'.') ||
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,
2457: -- SET view_type = 2
2458: -- WHERE view_type = 3
2459: -- AND PK1 is not null
2460: -- AND pk1 NOT IN (select /*+ hash_aj parallel(l) */ top_model_line_id
2461: -- from oe_order_lines_all l
2462: -- where l.shippable_flag = 'Y'
2463: -- and top_model_line_id is not null);
2464: -- COMMIT;
2465:
2638: -- SET view_type = 2
2639: -- WHERE view_type = 3
2640: -- AND PK1 is not null
2641: -- AND pk1 NOT IN (select /*+ hash_aj parallel(l) */ top_model_line_id
2642: -- from oe_order_lines_all l
2643: -- where l.shippable_flag = 'Y'
2644: -- and top_model_line_id is not null);
2645:
2646: -- COMMIT;