DBA Data[Home] [Help]

APPS.ECE_FLATFILE dependencies on ECE_INTERFACE_TABLES

Line 61: ece_interface_tables eit

57: atc.Data_Length Width,
58: atc.Data_Type Col_Type
59: From all_tab_columns atc,
60: ece_interface_columns eic,
61: ece_interface_tables eit
62: Where eit.Transaction_Type = cTransaction_Type
63: and eit.Interface_Table_Name = cInterface_Table
64: and eit.interface_table_id = eic.interface_table_id
65: and eic.Column_Name = atc.Column_Name

Line 128: From ECE_INTERFACE_TABLES EIT

124: End Loop;
125:
126: Select EIT.Extension_Table_Name -- select extension table name
127: Into cExtension_Table
128: From ECE_INTERFACE_TABLES EIT
129: Where EIT.Transaction_Type = cTransaction_Type
130: And EIT.Interface_Table_Name = cInterface_Table;
131:
132: -- build FROM, WHERE statements