eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_WF_DOCUMENT dependencies on PER_PEOPLE_F

Line 16: requestor per_people_f.full_name%TYPE,

12: unit_price po_requisition_lines.unit_price%TYPE,
13: line_amount NUMBER,
14: need_by_date po_requisition_lines.need_by_date%TYPE,
15: location hr_locations.location_code%TYPE,
16: requestor per_people_f.full_name%TYPE,
17: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
18: sugg_site po_requisition_lines.suggested_vendor_location%TYPE);
19:
20: TYPE history_record IS RECORD (

Line 48: l_forwarded_from per_people_f.full_name%TYPE;

44: l_header_msg VARCHAR2(200);
45: l_req_amount VARCHAR2(30);
46: l_tax_amount VARCHAR2(30);
47: l_description po_requisition_headers.description%TYPE;
48: l_forwarded_from per_people_f.full_name%TYPE;
49: l_preparer per_people_f.full_name%TYPE;
50: l_note VARCHAR2(240);
51:
52: l_document VARCHAR2(32000) := '';

Line 49: l_preparer per_people_f.full_name%TYPE;

45: l_req_amount VARCHAR2(30);
46: l_tax_amount VARCHAR2(30);
47: l_description po_requisition_headers.description%TYPE;
48: l_forwarded_from per_people_f.full_name%TYPE;
49: l_preparer per_people_f.full_name%TYPE;
50: l_note VARCHAR2(240);
51:
52: l_document VARCHAR2(32000) := '';
53: l_tax_amt NUMBER;

Line 263: l_approver per_people_f.full_name%TYPE;

259: l_header_msg VARCHAR2(200);
260: l_req_amount VARCHAR2(30);
261: l_tax_amount VARCHAR2(30);
262: l_description po_requisition_headers.description%TYPE;
263: l_approver per_people_f.full_name%TYPE;
264: l_preparer per_people_f.full_name%TYPE;
265: l_note VARCHAR2(240);
266:
267: l_document VARCHAR2(32000) := '';

Line 264: l_preparer per_people_f.full_name%TYPE;

260: l_req_amount VARCHAR2(30);
261: l_tax_amount VARCHAR2(30);
262: l_description po_requisition_headers.description%TYPE;
263: l_approver per_people_f.full_name%TYPE;
264: l_preparer per_people_f.full_name%TYPE;
265: l_note VARCHAR2(240);
266:
267: l_document VARCHAR2(32000) := '';
268: l_tax_amt NUMBER;

Line 468: l_approver per_people_f.full_name%TYPE;

464: l_header_msg VARCHAR2(200);
465: l_req_amount VARCHAR2(30);
466: l_tax_amount VARCHAR2(30);
467: l_description po_requisition_headers.description%TYPE;
468: l_approver per_people_f.full_name%TYPE;
469: l_preparer per_people_f.full_name%TYPE;
470: l_note VARCHAR2(240);
471:
472: l_document VARCHAR2(32000) := '';

Line 469: l_preparer per_people_f.full_name%TYPE;

465: l_req_amount VARCHAR2(30);
466: l_tax_amount VARCHAR2(30);
467: l_description po_requisition_headers.description%TYPE;
468: l_approver per_people_f.full_name%TYPE;
469: l_preparer per_people_f.full_name%TYPE;
470: l_note VARCHAR2(240);
471:
472: l_document VARCHAR2(32000) := '';
473: l_tax_amt NUMBER;

Line 673: l_rejected_by per_people_f.full_name%TYPE;

669: l_header_msg VARCHAR2(200);
670: l_req_amount VARCHAR2(30);
671: l_tax_amount VARCHAR2(30);
672: l_description po_requisition_headers.description%TYPE;
673: l_rejected_by per_people_f.full_name%TYPE;
674: l_preparer per_people_f.full_name%TYPE;
675: l_note VARCHAR2(240);
676:
677: l_document VARCHAR2(32000) := '';

Line 674: l_preparer per_people_f.full_name%TYPE;

670: l_req_amount VARCHAR2(30);
671: l_tax_amount VARCHAR2(30);
672: l_description po_requisition_headers.description%TYPE;
673: l_rejected_by per_people_f.full_name%TYPE;
674: l_preparer per_people_f.full_name%TYPE;
675: l_note VARCHAR2(240);
676:
677: l_document VARCHAR2(32000) := '';
678: l_tax_amt NUMBER;

Line 895: per_people_f per

891: rql.suggested_vendor_location
892: FROM po_requisition_lines rql,
893: mtl_system_items_kfv msi,
894: hr_locations hrt,
895: per_people_f per
896: WHERE rql.requisition_header_id = v_document_id
897: AND hrt.location_id (+) = rql.deliver_to_location_id
898: AND rql.item_id = msi.inventory_item_id(+)
899: AND nvl(msi.organization_id, rql.destination_organization_id) =

Line 1042: per_people_f per,

1038: poh.ACTION_DATE,
1039: poh.NOTE,
1040: poh.OBJECT_REVISION_NUM
1041: from po_action_history poh,
1042: per_people_f per,
1043: po_lookup_codes polc
1044: where OBJECT_TYPE_CODE = v_object_type
1045: and poh.action_code = polc.lookup_code
1046: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')

Line 1059: per_people_f per

1055: poh.ACTION_DATE,
1056: poh.NOTE,
1057: poh.OBJECT_REVISION_NUM
1058: from po_action_history poh,
1059: per_people_f per
1060: where OBJECT_TYPE_CODE = 'REQUISITION'
1061: and poh.action_code is null
1062: and per.person_id = poh.employee_id
1063: and trunc(sysdate) between per.effective_start_date