DBA Data[Home] [Help]

APPS.AME_API6 dependencies on AME_TRANS_APPROVAL_HISTORY

Line 29: from ame_trans_approval_history atah

25: ,atah.action_type_id
26: ,atah.group_or_chain_id
27: ,atah.api_insertion
28: ,atah.member_order_number
29: from ame_trans_approval_history atah
30: where atah.date_cleared is null
31: and atah.transaction_id = transactionIdIn
32: and atah.application_id = applicationIdIn
33: and atah.trans_history_id =

Line 36: from ame_trans_approval_history b

32: and atah.application_id = applicationIdIn
33: and atah.trans_history_id =
34: (
35: select max(b.trans_history_id)
36: from ame_trans_approval_history b
37: where atah.transaction_id = b.transaction_id
38: and atah.application_id = b.application_id
39: and atah.name = b.name
40: and atah.approver_category = b.approver_category