APPS.ECE_FLATFILE dependencies on ALL_TAB_COLUMNS

Line 59: From all_tab_columns atc,

55: eic.Position Position,
56: eic.Width New_width,
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

Line 76: From ALL_TAB_COLUMNS ATC, ECE_INTERFACE_COLUMNS EIC

72: Select min(EIC.Table_Name) Table_Name, EIC.Column_Name Column_Name,
73: EIC.Record_Number Record_Number, EIC.Position Position,
74: EIC.Width New_width,
75: ATC.Data_Length Width, ATC.Data_Type Col_Type
76: From ALL_TAB_COLUMNS ATC, ECE_INTERFACE_COLUMNS EIC
77: Where EIC.Transaction_Type = cTransaction_Type
78: and EIC.Interface_Table_Name = cInterface_Table
79: and EIC.Column_Name = ATC.Column_Name
80: and EIC.Table_Name = ATC.Table_Name