APPS.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 760: FND_LOOKUP_VALUES_VL LKUPS,

756: INTO X_UWQM_WORKITEM_DATA(i)
757: FROM IEU_UWQM_ITEMS UWQM,
758: IEU_UWQ_SEL_ENUMERATORS ENUM,
759: IEU_UWQM_PRIORITIES_TL PR,
760: FND_LOOKUP_VALUES_VL LKUPS,
761: FND_LOOKUP_VALUES_VL LKUPS1
762: WHERE UWQM.WORK_ITEM_ID = l_nw_item_list(i).work_item_id
763: AND ENUM.ENUM_TYPE_UUID = UWQM.IEU_ENUM_TYPE_UUID
764: AND PR.PRIORITY_ID = UWQM.PRIORITY_ID

Line 761: FND_LOOKUP_VALUES_VL LKUPS1

757: FROM IEU_UWQM_ITEMS UWQM,
758: IEU_UWQ_SEL_ENUMERATORS ENUM,
759: IEU_UWQM_PRIORITIES_TL PR,
760: FND_LOOKUP_VALUES_VL LKUPS,
761: FND_LOOKUP_VALUES_VL LKUPS1
762: WHERE UWQM.WORK_ITEM_ID = l_nw_item_list(i).work_item_id
763: AND ENUM.ENUM_TYPE_UUID = UWQM.IEU_ENUM_TYPE_UUID
764: AND PR.PRIORITY_ID = UWQM.PRIORITY_ID
765: AND LKUPS.LOOKUP_TYPE(+) = ENUM.WORK_Q_LABEL_LU_TYPE

Line 4065: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM

4061: BEGIN
4062:
4063: SELECT LKUPS.MEANING
4064: INTO L_WORK_TYPE
4065: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM
4066: WHERE ENUM.ENUM_TYPE_UUID = p_dist_workitem_data(n).IEU_ENUM_TYPE_UUID
4067: AND LKUPS.LOOKUP_TYPE(+) = ENUM.WORK_Q_LABEL_LU_TYPE
4068: AND LKUPS.VIEW_APPLICATION_ID(+) = ENUM.APPLICATION_ID
4069: AND LKUPS.LOOKUP_CODE(+) = WORK_Q_LABEL_LU_CODE;

Line 4283: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM

4279: BEGIN
4280:
4281: SELECT LKUPS.MEANING
4282: INTO L_WORK_TYPE
4283: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM
4284: WHERE ENUM.ENUM_TYPE_UUID = p_dist_del_workitem_data.IEU_ENUM_TYPE_UUID
4285: AND LKUPS.LOOKUP_TYPE(+) = ENUM.WORK_Q_LABEL_LU_TYPE
4286: AND LKUPS.VIEW_APPLICATION_ID(+) = ENUM.APPLICATION_ID
4287: AND LKUPS.LOOKUP_CODE(+) = WORK_Q_LABEL_LU_CODE;