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 4031: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM

4027: BEGIN
4028:
4029: SELECT LKUPS.MEANING
4030: INTO L_WORK_TYPE
4031: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM
4032: WHERE ENUM.ENUM_TYPE_UUID = p_dist_workitem_data(n).IEU_ENUM_TYPE_UUID
4033: AND LKUPS.LOOKUP_TYPE(+) = ENUM.WORK_Q_LABEL_LU_TYPE
4034: AND LKUPS.VIEW_APPLICATION_ID(+) = ENUM.APPLICATION_ID
4035: AND LKUPS.LOOKUP_CODE(+) = WORK_Q_LABEL_LU_CODE;

Line 4249: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM

4245: BEGIN
4246:
4247: SELECT LKUPS.MEANING
4248: INTO L_WORK_TYPE
4249: FROM FND_LOOKUP_VALUES_VL LKUPS, IEU_UWQ_SEL_ENUMERATORS ENUM
4250: WHERE ENUM.ENUM_TYPE_UUID = p_dist_del_workitem_data.IEU_ENUM_TYPE_UUID
4251: AND LKUPS.LOOKUP_TYPE(+) = ENUM.WORK_Q_LABEL_LU_TYPE
4252: AND LKUPS.VIEW_APPLICATION_ID(+) = ENUM.APPLICATION_ID
4253: AND LKUPS.LOOKUP_CODE(+) = WORK_Q_LABEL_LU_CODE;