APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on GL_SETS_OF_BOOKS

Line 476: ' GL_SETS_OF_BOOKS gsb,'||

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,'||
479: ' GL_SETS_OF_BOOKS gsb1,'||
480: ' MTL_SYSTEM_ITEMS_B item, '||

Line 479: ' GL_SETS_OF_BOOKS gsb1,'||

475: ' AR_SYSTEM_PARAMETERS_ALL aspa,'||
476: ' GL_SETS_OF_BOOKS gsb,'||
477: ' HR_ORGANIZATION_INFORMATION hoi,'||
478: ' OE_SYS_PARAMETERS_ALL ospa,'||
479: ' GL_SETS_OF_BOOKS gsb1,'||
480: ' MTL_SYSTEM_ITEMS_B item, '||
481: ' (select p.line_id, sum(decode(p.list_line_type_code, ''COST'', '||
482: ' p.adjusted_amount, null)) cost, '||
483: ' sum(decode(p.list_line_type_code, ''FREIGHT_CHARGE'', '||

Line 820: GL_SETS_OF_BOOKS gsb,

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,
823: GL_SETS_OF_BOOKS gsb1,
824: MTL_SYSTEM_ITEMS_B item

Line 823: GL_SETS_OF_BOOKS gsb1,

819: AR_SYSTEM_PARAMETERS_ALL aspa,
820: GL_SETS_OF_BOOKS gsb,
821: HR_ORGANIZATION_INFORMATION hoi,
822: OE_SYS_PARAMETERS_ALL ospa,
823: GL_SETS_OF_BOOKS gsb1,
824: MTL_SYSTEM_ITEMS_B item
825: WHERE log.line_id = l.line_id
826: -- AND log.last_update_date < g_incre_start_date
827: AND l.header_id = h.header_id

Line 932: -- GL_SETS_OF_BOOKS gsb,

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,
935: -- GL_SETS_OF_BOOKS gsb1,
936: -- MTL_SYSTEM_ITEMS_B item

Line 935: -- GL_SETS_OF_BOOKS gsb1,

931: -- AR_SYSTEM_PARAMETERS_ALL aspa,
932: -- GL_SETS_OF_BOOKS gsb,
933: -- HR_ORGANIZATION_INFORMATION hoi,
934: -- OE_SYSTEM_PARAMETERS_ALL ospa,
935: -- GL_SETS_OF_BOOKS gsb1,
936: -- MTL_SYSTEM_ITEMS_B item
937: -- WHERE log.top_model_line_id = pl.top_model_line_id
938: -- AND not exists (select '1' from isc_tmp_book_sum2 tmp where tmp.pk1 = pl.line_id)
939: -- AND pl.header_id = h.header_id