DBA Data[Home] [Help]

APPS.POR_CONTRACTOR_NOTIFY dependencies on PO_VENDORS

Line 82: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;

78: L_STATUS varchar2(1);
79: L_EXP_MSG varchar2(100);
80: L_REQUISITION_LINE_ID PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
81: L_LINE_NUM PO_REQUISITION_LINES_ALL.LINE_NUM%TYPE;
82: L_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
83:
84: BEGIN
85:
86: L_REQ_HEADER_ID := WF_ENGINE.GETITEMATTRNUMBER

Line 218: PO_VENDORS POV

214: SELECT PORL.LINE_NUM, POV.VENDOR_NAME
215: INTO L_LINE_NUM, L_VENDOR_NAME
216: FROM PO_REQUISITION_SUPPLIERS PLS,
217: PO_REQUISITION_LINES_ALL PORL,
218: PO_VENDORS POV
219: WHERE PORL.REQUISITION_LINE_ID = PLS.REQUISITION_LINE_ID
220: AND PLS.REQUISITION_SUPPLIER_ID = L_REQUISITION_SUPPLIER_ID
221: AND PLS.VENDOR_ID = POV.VENDOR_ID;
222: