DBA Data[Home] [Help]

APPS.FEM_TABLE_REGISTRATION_PKG dependencies on FEM_DIMENSIONS_TL

Line 701: (SELECT fd.dimension_name FROM fem_dimensions_tl fd

697: dtc.data_length,
698: dtc.data_precision,
699: nvl(fcr.fem_data_type_code,dtc.data_type) as cpm_datatype,
700: fcr.dimension_id,
701: (SELECT fd.dimension_name FROM fem_dimensions_tl fd
702: WHERE fd.dimension_id = fcr.dimension_id
703: AND fd.language = USERENV('LANG')
704: AND rownum = 1) as Dimension_name,
705: fcr.uom_column_name,

Line 780: FROM fem_dimensions_tl fd

776: dump.data_precision,
777: nvl(ftc.fem_data_type_code,dump.data_type) as cpm_datatype,
778: ftc.dimension_id,
779: DECODE(ftc.dimension_id, NULL, NULL, (SELECT fd.dimension_name
780: FROM fem_dimensions_tl fd
781: WHERE fd.dimension_id = ftc.dimension_id
782: AND fd.language = USERENV('LANG')
783: AND rownum = 1)) as Dimension_name,
784: ftc.uom_column_name,

Line 941: FROM fem_dimensions_tl fd

937: dt.data_precision,
938: dtc.fem_data_type_code,
939: dtc.dimension_id,
940: DECODE(dtc.dimension_id, NULL, NULL, (SELECT fd.dimension_name
941: FROM fem_dimensions_tl fd
942: WHERE fd.dimension_id = dtc.dimension_id
943: AND fd.language = USERENV('LANG')
944: AND rownum = 1)),
945: dtc.uom_column_name,

Line 1019: FROM fem_dimensions_tl fd

1015: dt.data_precision,
1016: dtc.fem_data_type_code,
1017: dtc.dimension_id,
1018: DECODE(dtc.dimension_id, NULL, NULL, (SELECT fd.dimension_name
1019: FROM fem_dimensions_tl fd
1020: WHERE fd.dimension_id = dtc.dimension_id
1021: AND fd.language = USERENV('LANG')
1022: AND rownum = 1)),
1023: dtc.uom_column_name,