DBA Data[Home] [Help]

APPS.INV_LOT_SEL_ATTR dependencies on FND_APPLICATION_VL

Line 724: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

720:
721:
722: SELECT df.context_required_flag
723: INTO v_dflex_context_flag
724: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
725: WHERE a.application_short_name = p_application_short_name
726: AND df.application_id = a.application_id
727: AND df.descriptive_flexfield_name = p_flex_name
728: AND a.application_id = df.table_application_id;

Line 767: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

763: BEGIN
764:
765: SELECT df.context_user_override_flag
766: INTO l_context_override_flag
767: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
768: WHERE a.application_short_name = p_application_short_name
769: AND df.application_id = a.application_id
770: AND df.descriptive_flexfield_name = p_flex_name
771: AND a.application_id = df.table_application_id;

Line 2123: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df

2119:
2120: BEGIN
2121: SELECT df.context_required_flag
2122: INTO l_context_req_flag
2123: FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
2124: WHERE a.application_short_name = 'INV'
2125: AND df.application_id = a.application_id
2126: AND df.descriptive_flexfield_name = p_flex_name
2127: AND a.application_id = df.table_application_id;