DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_REQ_PVT dependencies on WF_ITEMS

Line 325: l_itemtype wf_items.item_type%TYPE;

321: l_req_rowid ROWID;
322: l_req_num po_requisition_headers.segment1%TYPE;
323: l_doc_type po_document_types_all.type_name%TYPE;
324: l_auth_status po_headers.authorization_status%TYPE;
325: l_itemtype wf_items.item_type%TYPE;
326: l_itemkey wf_items.item_key%TYPE;
327:
328: -- Local Variables used in the same procedure.
329:

Line 326: l_itemkey wf_items.item_key%TYPE;

322: l_req_num po_requisition_headers.segment1%TYPE;
323: l_doc_type po_document_types_all.type_name%TYPE;
324: l_auth_status po_headers.authorization_status%TYPE;
325: l_itemtype wf_items.item_type%TYPE;
326: l_itemkey wf_items.item_key%TYPE;
327:
328: -- Local Variables used in the same procedure.
329:
330: l_preparer_id NUMBER;

Line 897: wf_items wfi

893: FROM wf_notifications wfn,
894: wf_item_activity_statuses wfa,
895: po_requisition_headers por,
896: po_document_types_vl pdt,
897: wf_items wfi
898: WHERE wfn.notification_id = wfa.notification_id
899: AND wfi.item_key = wfa.item_key
900: and wfi.item_type=wfa.item_type
901: AND por.wf_item_type=wfi.parent_item_type