DBA Data[Home] [Help]

APPS.OE_APPROVALS_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1172: -- from wf_item_activity_statuses_v

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

Line 1178: from WF_ITEM_ACTIVITY_STATUSES

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

Line 1262: -- from wf_item_activity_statuses_v

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

Line 1268: from WF_ITEM_ACTIVITY_STATUSES

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