DBA Data[Home] [Help]

APPS.OE_APPROVALS_WF dependencies on OE_TRANSACTION_TYPES_ALL

Line 3339: FROM oe_transaction_types_all

3335:
3336:
3337: SELECT use_ame_approval
3338: INTO l_ame_used
3339: FROM oe_transaction_types_all
3340: WHERE transaction_type_id = (SELECT order_type_id
3341: FROM oe_blanket_headers_all -- 16084377 AME BSA
3342: WHERE header_id = TO_NUMBER (itemkey));
3343:

Line 3348: FROM oe_transaction_types_all

3344: ELSE
3345:
3346: SELECT use_ame_approval
3347: INTO l_ame_used
3348: FROM oe_transaction_types_all
3349: WHERE transaction_type_id = (SELECT order_type_id
3350: FROM oe_order_headers_all
3351: WHERE header_id = TO_NUMBER (itemkey));
3352: