APPS.PO_SIGNATURE_PVT dependencies on PO_VENDORS

Line 18: -- po_headers_all and po_vendors

14:
15:
16: --Cursor to select the PO details to be used in the notification message bodies
17: -- SQL What:selects the PO details and the vendor details from
18: -- po_headers_all and po_vendors
19: -- SQL Why :To show the details in the Notifications of the Document
20: -- Signature Process.
21: -- SQL Join: PO_HEADER_ID, VENDOR_ID
22:

Line 37: PO_VENDORS VO,

33: DECODE(PHA.vendor_contact_id, NULL, NULL,
34: VC.last_name||', '||VC.first_name) vendor_contact,
35: PHA.blanket_total_amount
36: FROM PO_HEADERS_ALL PHA,
37: PO_VENDORS VO,
38: PO_VENDOR_CONTACTS VC,
39: HR_LOCATIONS_ALL_TL HRL_S,
40: HR_LOCATIONS_ALL_TL HRL_B
41: WHERE PHA.po_header_id = p_po_header_id

Line 93: l_vendor_name PO_VENDORS.vendor_name%TYPE;

89: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
90: l_username FND_USER.user_name%TYPE;
91: l_user_display_name FND_USER.description%TYPE;
92: l_progress VARCHAR2(300);
93: l_vendor_name PO_VENDORS.vendor_name%TYPE;
94: l_doc_string VARCHAR2(200);
95: l_preparer_user_name WF_USERS.name%TYPE;
96: l_binding_exception EXCEPTION;
97: -- Forward port of bug 3897526. Display PDF attachment even when PO

Line 1681: l_supplier_org PO_VENDORS.vendor_name%TYPE;

1677: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1678: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1679: l_supplier_displayname WF_LOCAL_ROLES.display_name%TYPE;
1680: l_supplier_username WF_LOCAL_ROLES.name%TYPE;
1681: l_supplier_org PO_VENDORS.vendor_name%TYPE;
1682: l_supplier_userid WF_LOCAL_ROLES.orig_system_id%TYPE;
1683: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1684: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1685: l_doc_string VARCHAR2(200);