APPS.AME_API6 dependencies on AME_TRANS_APPROVAL_HISTORY

Line 76: from ame_trans_approval_history atah

72: ,atah.action_type_id
73: ,atah.group_or_chain_id
74: ,atah.api_insertion
75: ,atah.member_order_number
76: from ame_trans_approval_history atah
77: where atah.date_cleared is null
78: and atah.transaction_id = transactionIdIn
79: and atah.application_id = applicationIdIn
80: and atah.row_timestamp =

Line 83: from ame_trans_approval_history b

79: and atah.application_id = applicationIdIn
80: and atah.row_timestamp =
81: (
82: select max(b.row_timestamp)
83: from ame_trans_approval_history b
84: where atah.transaction_id = b.transaction_id
85: and atah.application_id = b.application_id
86: and atah.name = b.name
87: and atah.approver_category = b.approver_category

Line 289: ,ame_trans_approval_history h

285: ,ol.group_or_chain_id
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

Line 345: FROM ame_trans_approval_history b

341: AND lookup3.lookup_code (+) = ame_approver_type_pkg.getapproverorigsystem3 (ol.name)
342: AND h.row_timestamp =
343: (
344: SELECT max (b.row_timestamp)
345: FROM ame_trans_approval_history b
346: WHERE h.transaction_id = b.transaction_id
347: AND h.application_id = b.application_id
348: AND h.name = b.name
349: AND h.approver_category = b.approver_category

Line 377: FROM ame_trans_approval_history x

373: WHERE NOT EXISTS
374: (
375: SELECT x.transaction_id
376: ,x.application_id
377: FROM ame_trans_approval_history x
378: WHERE ol.transaction_id = x.transaction_id
379: AND ol.name = x.name
380: AND ol.application_id = x.application_id
381: AND ol.item_class = x.item_class