APPS.QLTAUFLB dependencies on PO_LOOKUP_CODES

Line 206: FROM PO_LOOKUP_CODES

202: AND nvl(a.low_value_lookup, 0) = nvl(b.low_value_lookup, 0)
203: AND nvl(b.low_value_other, 0) = decode(nvl(a.low_value_other, 0),
204: 'ACCEPT',
205: (SELECT DISPLAYED_FIELD
206: FROM PO_LOOKUP_CODES
207: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
208: AND LOOKUP_CODE = a.low_value_other),
209: 'REJECT',
210: (SELECT DISPLAYED_FIELD

Line 211: FROM PO_LOOKUP_CODES

207: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
208: AND LOOKUP_CODE = a.low_value_other),
209: 'REJECT',
210: (SELECT DISPLAYED_FIELD
211: FROM PO_LOOKUP_CODES
212: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
213: AND LOOKUP_CODE = a.low_value_other),
214: nvl(a.low_value_other, 0))
215: AND nvl(a.high_value_other, 0) = nvl(b.high_value_other, 0)

Line 276: FROM PO_LOOKUP_CODES

272: AND nvl(a.low_value_lookup, 0) = nvl(b.low_value_lookup, 0)
273: AND nvl(b.low_value_other, 0) = decode(nvl(a.low_value_other, 0),
274: 'ACCEPT',
275: (SELECT DISPLAYED_FIELD
276: FROM PO_LOOKUP_CODES
277: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
278: AND LOOKUP_CODE = a.low_value_other),
279: 'REJECT',
280: (SELECT DISPLAYED_FIELD

Line 281: FROM PO_LOOKUP_CODES

277: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
278: AND LOOKUP_CODE = a.low_value_other),
279: 'REJECT',
280: (SELECT DISPLAYED_FIELD
281: FROM PO_LOOKUP_CODES
282: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
283: AND LOOKUP_CODE = a.low_value_other),
284: nvl(a.low_value_other, 0))
285: AND nvl(a.high_value_other, 0) = nvl(b.high_value_other, 0)

Line 411: FROM po_lookup_codes

407: WHERE plan_id = X_Plan_id
408: AND char_id = 8
409: AND low_value_other IN
410: (SELECT displayed_field
411: FROM po_lookup_codes
412: WHERE lookup_type='ERT RESULTS ACTION'));
413:
414: DELETE FROM qa_plan_char_action_triggers
415: WHERE plan_id = X_Plan_id

Line 419: FROM po_lookup_codes

415: WHERE plan_id = X_Plan_id
416: AND char_id = 8
417: AND low_value_other IN
418: (SELECT displayed_field
419: FROM po_lookup_codes
420: WHERE lookup_type='ERT RESULTS ACTION');*/
421:
422: --
423: -- Bug# 5739330.

Line 539: FROM PO_LOOKUP_CODES

535:
536: IF X_COPY_PLAN_ID IN (1,2147483637) AND QPCAT.LOW_VALUE_OTHER IN ('ACCEPT', 'REJECT') THEN
537: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
538: SET LOW_VALUE_OTHER = (SELECT DISPLAYED_FIELD
539: FROM PO_LOOKUP_CODES
540: WHERE LOOKUP_TYPE = 'ERT RESULTS ACTION'
541: AND LOOKUP_CODE = QPCAT.LOW_VALUE_OTHER)
542: WHERE PLAN_CHAR_ACTION_TRIGGER_ID = ACTION_TRIGGER_ID;
543: END IF;