APPS.OE_APPROVALS_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1174: -- from wf_item_activity_statuses_v

1170:
1171:
1172: -- select to_number(ITEM_KEY)
1173: -- into l_transaction_id
1174: -- from wf_item_activity_statuses_v
1175: -- where NOTIFICATION_ID = to_number(document_id);
1176:
1177: --Replaced with
1178: select to_number(ITEM_KEY)

Line 1180: from WF_ITEM_ACTIVITY_STATUSES

1176:
1177: --Replaced with
1178: select to_number(ITEM_KEY)
1179: into l_transaction_id
1180: from WF_ITEM_ACTIVITY_STATUSES
1181: where NOTIFICATION_ID = to_number(document_id);
1182:
1183: l_role := Get_Current_Approver_internal (l_transaction_id);
1184:

Line 1264: -- from wf_item_activity_statuses_v

1260: END IF;
1261:
1262: -- select to_number(ITEM_KEY)
1263: -- into l_transaction_id
1264: -- from wf_item_activity_statuses_v
1265: -- where NOTIFICATION_ID = to_number(document_id);
1266:
1267: --Replaced with
1268: select to_number(ITEM_KEY)

Line 1270: from WF_ITEM_ACTIVITY_STATUSES

1266:
1267: --Replaced with
1268: select to_number(ITEM_KEY)
1269: into l_transaction_id
1270: from WF_ITEM_ACTIVITY_STATUSES
1271: where NOTIFICATION_ID = to_number(document_id);
1272:
1273:
1274: l_sales_document_type_code := wf_engine.GetItemAttrText(

Line 2967: FROM wf_items wfi, wf_item_activity_statuses wfias

2963: p_itemkey IN wf_items.parent_item_key%TYPE
2964: )
2965: IS
2966: SELECT wfi.item_type, wfi.item_key
2967: FROM wf_items wfi, wf_item_activity_statuses wfias
2968: WHERE wfi.parent_item_key = p_itemkey
2969: AND wfi.item_type = 'OEAME'
2970: AND wfi.parent_item_type = p_itemtype
2971: AND wfias.item_type = wfi.item_type

Line 3375: FROM wf_item_activity_statuses_h wiash,

3371: END IF ;
3372: BEGIN
3373: SELECT 'Y'
3374: INTO l_rejected_once
3375: FROM wf_item_activity_statuses_h wiash,
3376: wf_process_activities wpa
3377: WHERE wiash.process_activity = wpa.instance_id
3378: AND wiash.item_type = itemtype
3379: AND wiash.item_key = itemkey