APPS.AME_API6 dependencies on FND_LOOKUPS

Line 290: ,fnd_lookups lookup

286: ,ol.item_class
287: ,ol.item_id
288: FROM ame_temp_old_approver_lists ol
289: ,ame_trans_approval_history h
290: ,fnd_lookups lookup
291: ,fnd_lookups lookup2
292: ,fnd_lookups lookup3
293: ,ame_approval_groups_vl apg
294: WHERE ol.transaction_id = h.transaction_id

Line 291: ,fnd_lookups lookup2

287: ,ol.item_id
288: FROM ame_temp_old_approver_lists ol
289: ,ame_trans_approval_history h
290: ,fnd_lookups lookup
291: ,fnd_lookups lookup2
292: ,fnd_lookups lookup3
293: ,ame_approval_groups_vl apg
294: WHERE ol.transaction_id = h.transaction_id
295: AND ol.application_id = h.application_id

Line 292: ,fnd_lookups lookup3

288: FROM ame_temp_old_approver_lists ol
289: ,ame_trans_approval_history h
290: ,fnd_lookups lookup
291: ,fnd_lookups lookup2
292: ,fnd_lookups lookup3
293: ,ame_approval_groups_vl apg
294: WHERE ol.transaction_id = h.transaction_id
295: AND ol.application_id = h.application_id
296: AND ol.name = h.name

Line 369: ,fnd_lookups lookup

365: ,ol.group_or_chain_id
366: ,ol.item_class
367: ,ol.item_id
368: FROM ame_temp_old_approver_lists ol
369: ,fnd_lookups lookup
370: ,fnd_lookups lookup2
371: ,fnd_lookups lookup3
372: ,ame_approval_groups_vl apg
373: WHERE NOT EXISTS

Line 370: ,fnd_lookups lookup2

366: ,ol.item_class
367: ,ol.item_id
368: FROM ame_temp_old_approver_lists ol
369: ,fnd_lookups lookup
370: ,fnd_lookups lookup2
371: ,fnd_lookups lookup3
372: ,ame_approval_groups_vl apg
373: WHERE NOT EXISTS
374: (

Line 371: ,fnd_lookups lookup3

367: ,ol.item_id
368: FROM ame_temp_old_approver_lists ol
369: ,fnd_lookups lookup
370: ,fnd_lookups lookup2
371: ,fnd_lookups lookup3
372: ,ame_approval_groups_vl apg
373: WHERE NOT EXISTS
374: (
375: SELECT x.transaction_id