APPS.ISC_EDW_BACKLOGS_F_SIZE dependencies on OE_TRANSACTION_TYPES_TL

Line 44: oe_transaction_types_tl ot,

40: ||'-'|| ot.transaction_type_id
41: ||'-'|| nvl( os_2.order_source_id, os_1.order_source_id)
42: ||'-'|| fspa.set_of_books_id BACKLOGS_PK
43: FROM edw_local_instance inst,
44: oe_transaction_types_tl ot,
45: oe_order_lines_all pl,
46: oe_order_headers_all h,
47: oe_order_lines_all l,
48: oe_order_sources os_1,

Line 164: FROM OE_TRANSACTION_TYPES_TL;

160: FROM OE_ORDER_SOURCES;
161:
162: CURSOR c_7 IS
163: SELECT nvl(avg(nvl(vsize(name),0)),0)
164: FROM OE_TRANSACTION_TYPES_TL;
165:
166: CURSOR c_8 IS
167: SELECT nvl(avg(nvl(vsize(to_char(set_of_books_id)),0)),0),
168: nvl(avg(nvl(vsize(set_of_books_id),0)),0)