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_REQ_NOTIFICATION_R11 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 47: l_approver per_people_f.full_name%TYPE;

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

Line 48: l_preparer per_people_f.full_name%TYPE;

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

Line 223: l_approver per_people_f.full_name%TYPE;

219: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
220: l_header_msg VARCHAR2(200);
221: l_req_amount VARCHAR2(30);
222: l_description po_requisition_headers.description%TYPE;
223: l_approver per_people_f.full_name%TYPE;
224: l_preparer per_people_f.full_name%TYPE;
225: l_note VARCHAR2(240);
226:
227: l_document VARCHAR2(32000) := '';

Line 224: l_preparer per_people_f.full_name%TYPE;

220: l_header_msg VARCHAR2(200);
221: l_req_amount VARCHAR2(30);
222: l_description po_requisition_headers.description%TYPE;
223: l_approver per_people_f.full_name%TYPE;
224: l_preparer per_people_f.full_name%TYPE;
225: l_note VARCHAR2(240);
226:
227: l_document VARCHAR2(32000) := '';
228:

Line 405: l_approver per_people_f.full_name%TYPE;

401: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
402: l_req_amount VARCHAR2(30);
403: l_header_msg VARCHAR2(200);
404: l_description po_requisition_headers.description%TYPE;
405: l_approver per_people_f.full_name%TYPE;
406: l_preparer per_people_f.full_name%TYPE;
407: l_note VARCHAR2(240);
408:
409: l_document VARCHAR2(32000) := '';

Line 406: l_preparer per_people_f.full_name%TYPE;

402: l_req_amount VARCHAR2(30);
403: l_header_msg VARCHAR2(200);
404: l_description po_requisition_headers.description%TYPE;
405: l_approver per_people_f.full_name%TYPE;
406: l_preparer per_people_f.full_name%TYPE;
407: l_note VARCHAR2(240);
408:
409: l_document VARCHAR2(32000) := '';
410:

Line 586: l_rejected_by per_people_f.full_name%TYPE;

582: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
583: l_req_amount VARCHAR2(30);
584: l_header_msg VARCHAR2(200);
585: l_description po_requisition_headers.description%TYPE;
586: l_rejected_by per_people_f.full_name%TYPE;
587: l_preparer per_people_f.full_name%TYPE;
588: l_note VARCHAR2(240);
589:
590: l_document VARCHAR2(32000) := '';

Line 587: l_preparer per_people_f.full_name%TYPE;

583: l_req_amount VARCHAR2(30);
584: l_header_msg VARCHAR2(200);
585: l_description po_requisition_headers.description%TYPE;
586: l_rejected_by per_people_f.full_name%TYPE;
587: l_preparer per_people_f.full_name%TYPE;
588: l_note VARCHAR2(240);
589:
590: l_document VARCHAR2(32000) := '';
591:

Line 792: per_people_f per

788: rql.suggested_vendor_location
789: FROM po_requisition_lines rql,
790: mtl_system_items_kfv msi,
791: hr_locations hrt,
792: per_people_f per
793: WHERE rql.requisition_header_id = v_document_id
794: AND NVL(rql.cancel_flag,'N') = 'N'
795: AND hrt.location_id (+) = rql.deliver_to_location_id
796: AND rql.item_id is not null

Line 819: per_people_f per

815: rql.suggested_vendor_name,
816: rql.suggested_vendor_location
817: FROM po_requisition_lines rql,
818: hr_locations hrt,
819: per_people_f per
820: WHERE rql.requisition_header_id = v_document_id
821: AND NVL(rql.cancel_flag,'N') = 'N'
822: AND hrt.location_id (+) = rql.deliver_to_location_id
823: AND rql.item_id is NULL

Line 1060: per_people_f per

1056: rql.suggested_vendor_location
1057: FROM po_requisition_lines rql,
1058: mtl_system_items_kfv msi,
1059: hr_locations hrt,
1060: per_people_f per
1061: WHERE rql.requisition_header_id = v_document_id
1062: AND NVL(rql.cancel_flag,'N') = 'N'
1063: AND hrt.location_id (+) = rql.deliver_to_location_id
1064: AND rql.item_id is not null

Line 1087: per_people_f per

1083: rql.suggested_vendor_name,
1084: rql.suggested_vendor_location
1085: FROM po_requisition_lines rql,
1086: hr_locations hrt,
1087: per_people_f per
1088: WHERE rql.requisition_header_id = v_document_id
1089: AND NVL(rql.cancel_flag,'N') = 'N'
1090: AND hrt.location_id (+) = rql.deliver_to_location_id
1091: AND rql.item_id is NULL

Line 1302: per_people_f per,

1298: poh.ACTION_DATE,
1299: poh.NOTE,
1300: poh.OBJECT_REVISION_NUM
1301: from po_action_history poh,
1302: per_people_f per,
1303: po_lookup_codes polc
1304: where OBJECT_TYPE_CODE = v_object_type
1305: and poh.action_code = polc.lookup_code
1306: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')

Line 1319: per_people_f per

1315: poh.ACTION_DATE,
1316: poh.NOTE,
1317: poh.OBJECT_REVISION_NUM
1318: from po_action_history poh,
1319: per_people_f per
1320: where OBJECT_TYPE_CODE = v_object_type
1321: and poh.action_code is null
1322: and per.person_id = poh.employee_id
1323: and trunc(sysdate) between per.effective_start_date