DBA Data[Home] [Help]

APPS.INVIDIT1 dependencies on MFG_LOOKUPS

Line 887: from mfg_lookups

883: if (X_conversion is not null) then
884: begin
885: select meaning
886: into X_conversion_dsp
887: from mfg_lookups
888: where lookup_type = 'MTL_CONVERSION_TYPE'
889: and lookup_code = X_conversion;
890: exception
891: when NO_DATA_FOUND then

Line 1023: from mfg_lookups

1019: if (p_eam_activity_type_code is not null) then
1020: begin
1021: select meaning
1022: into x_eam_activity_type
1023: from mfg_lookups
1024: where lookup_type = 'MTL_EAM_ACTIVITY_TYPE'
1025: and lookup_code = p_eam_activity_type_code;
1026: exception
1027: when NO_DATA_FOUND then

Line 1036: from mfg_lookups

1032: if (p_eam_activity_cause_code is not null) then
1033: begin
1034: select meaning
1035: into x_eam_activity_cause
1036: from mfg_lookups
1037: where lookup_type = 'MTL_EAM_ACTIVITY_CAUSE'
1038: and lookup_code = p_eam_activity_cause_code;
1039: exception
1040: when NO_DATA_FOUND then

Line 1049: from mfg_lookups

1045: if (p_eam_act_shutdown_status is not null) then
1046: begin
1047: select meaning
1048: into x_eam_act_shutdown_status_dsp
1049: from mfg_lookups
1050: where lookup_type = 'BOM_EAM_SHUTDOWN_TYPE'
1051: and lookup_code = p_eam_act_shutdown_status;
1052: exception
1053: when NO_DATA_FOUND then