APPS.EC_OUTBOUND_STAGE dependencies on ECE_INTERFACE_TABLES

Line 44: from ece_interface_tables eit,

40: select eel.start_element,
41: eit.interface_table_id,
42: eit.key_column_name,
43: eit.primary_address_type
44: from ece_interface_tables eit,
45: ece_level_matrices elm,
46: ece_external_levels eel
47: where eit.transaction_type = p_transaction_type
48: and eit.interface_table_id = elm.interface_table_id

Line 63: from ece_interface_tables eit,

59: select DISTINCT(eic.record_number) record_number
60: , eel.external_level external_level
61: , eel.start_element start_element
62: , COUNT(*) counter
63: from ece_interface_tables eit,
64: ece_interface_columns eic,
65: ece_level_matrices elm,
66: ece_external_levels eel
67: where eit.transaction_type = p_transaction_type

Line 492: and the Staging table. This information is seeded in the ECE_INTERFACE_TABLES

488: END Fetch_Stage_Data;
489:
490: /**
491: This procedures loads the mapping information between the Flat File
492: and the Staging table. This information is seeded in the ECE_INTERFACE_TABLES
493: and ECE_INTERFACE_COLUMNS. The mapping information is loaded into the Local Body
494: PL/SQL table variable for a given transaction Type, record_number and level.
495: This PL/SQL table loaded with Mapping information is visible only to the functions
496: and procedures defined within this package.

Line 520: FROM ece_interface_tables eit,

516: eic.record_layout_qualifier,
517: eic.data_type,
518: eic.position,
519: eic.width
520: FROM ece_interface_tables eit,
521: ece_level_matrices elm,
522: ece_external_levels eel,
523: ece_interface_columns eic
524: WHERE eit.interface_table_id = eic.interface_table_id