DBA Data[Home] [Help]

APPS.FTP_TP_PKG dependencies on FEM_TAB_COLUMNS_V

Line 2634: FROM fem_tab_columns_v i, FTP_RATE_OUTPUT_MAPPING_RULE j, ftp_tp_proc_tabls_params k

2630: max(DECODE(HIST_STAT_SPREAD_COL_NAME, column_name, HIST_STAT_SPREAD_COL_NAME, NULL,NULL, -1)) as hist_stat_spr,
2631: max(DECODE(CUR_STAT_SPREAD_COL_NAME, column_name, CUR_STAT_SPREAD_COL_NAME, NULL,NULL, -1)) as cur_stat_spr,
2632: max(DECODE(ADJUSTMENT_AMOUNT_COL_NAME, column_name, ADJUSTMENT_AMOUNT_COL_NAME, NULL,NULL, -1)) as adj_amt,
2633: max(DECODE(CUR_OAS_COL_NAME, column_name, CUR_OAS_COL_NAME, NULL,NULL, -1)) as cur_option
2634: FROM fem_tab_columns_v i, FTP_RATE_OUTPUT_MAPPING_RULE j, ftp_tp_proc_tabls_params k
2635: WHERE i.table_name = j. FTP_ACCOUNT_TABLE_NAME
2636: AND j. FTP_ACCOUNT_TABLE_NAME = k.table_name
2637: AND job_id = jobid
2638: AND k.object_definition_id = process_info.obj_id