DBA Data[Home] [Help]

APPS.EC_INBOUND_STAGE dependencies on ECE_INTERFACE_COLUMNS

Line 812: and ECE_INTERFACE_COLUMNS. The mapping information is loaded into the Local Body

808:
809: /**
810: This procedures loads the mapping information between the Flat File
811: and the Staging table. This information is seeded in the ECE_INTERFACE_TABLES
812: and ECE_INTERFACE_COLUMNS. The mapping information is loaded into the Local Body
813: PL/SQL table variable for a given transaction Type and its level. This PL/SQL table
814: loaded with Mapping information is visible only to the functions and procedures
815: defined within this package.
816: **/

Line 834: FROM ece_interface_columns eic

830: eic.staging_column,
831: eic.record_number,
832: eic.position,
833: eic.width
834: FROM ece_interface_columns eic
835: WHERE eic.external_level = p_level
836: AND eic.map_id = p_map_id
837: AND eic.record_number IS NOT NULL
838: AND eic.position IS NOT NULL