DBA Data[Home] [Help]

APPS.ISC_EDW_BOOKINGS_F_C dependencies on ISC_EDW_BOOKINGS_F_FCV

Line 148: SELECT /*+ leading(ISC_EDW_BOOKINGS_F_FCV.ISCBV_BOOKINGS_FCV.ftp) */

144: USER_MEASURE4,
145: USER_MEASURE5,
146: OPERATION_CODE,
147: COLLECTION_STATUS)
148: SELECT /*+ leading(ISC_EDW_BOOKINGS_F_FCV.ISCBV_BOOKINGS_FCV.ftp) */
149: AGREEMENT_ID,
150: AGREEMENT_TYPE_FK,
151: BILL_TO_CUST_FK,
152: BILL_TO_LOC_FK,

Line 269: FROM ISC_EDW_BOOKINGS_F_FCV

265: USER_MEASURE4,
266: USER_MEASURE5,
267: NULL, -- OPERATION_CODE
268: 'READY'
269: FROM ISC_EDW_BOOKINGS_F_FCV
270: WHERE view_type = p_view_type
271: AND seq_id = p_seq_id;
272:
273: RETURN(sql%rowcount);