APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on MTL_SYSTEM_ITEMS_B

Line 480: ' MTL_SYSTEM_ITEMS_B item, '||

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'', '||
484: ' decode(nvl(p.applied_flag, ''Y''), ''Y'', '||

Line 824: MTL_SYSTEM_ITEMS_B item

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
828: AND l.line_id = opa.line_id (+)

Line 936: -- MTL_SYSTEM_ITEMS_B item

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
940: -- AND h.org_id = aspa.org_id