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_REQCHANGEREQUESTNOTIF_PVT dependencies on PER_PEOPLE_F

Line 220: requestor per_people_f.full_name%TYPE,

216: unit_price po_requisition_lines.unit_price%TYPE,
217: line_amount NUMBER,
218: need_by_date po_requisition_lines.need_by_date%TYPE,
219: location hr_locations.location_code%TYPE,
220: requestor per_people_f.full_name%TYPE,
221: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
222: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
223: txn_curr_code po_requisition_lines.currency_code%TYPE,
224: curr_unit_price po_requisition_lines.currency_unit_price%TYPE,

Line 1657: per_people_f per,

1653: poh.ACTION_DATE,
1654: poh.NOTE,
1655: poh.OBJECT_REVISION_NUM
1656: from po_action_history poh,
1657: per_people_f per,
1658: po_lookup_codes polc
1659: where OBJECT_TYPE_CODE = v_object_type
1660: and poh.action_code = polc.lookup_code
1661: and POLC.LOOKUP_TYPE IN ('APPROVER ACTIONS','CONTROL ACTIONS')

Line 1674: per_people_f per

1670: poh.ACTION_DATE,
1671: poh.NOTE,
1672: poh.OBJECT_REVISION_NUM
1673: from po_action_history poh,
1674: per_people_f per
1675: where OBJECT_TYPE_CODE = v_object_type
1676: and poh.action_code is null
1677: and per.person_id = poh.employee_id
1678: and trunc(sysdate) between per.effective_start_date

Line 1841: FROM per_people_f per,

1837:
1838: CURSOR pending_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS
1839:
1840: SELECT pal.SEQUENCE_NUM,per.FULL_NAME,null,null,null,null
1841: FROM per_people_f per,
1842: po_approval_list_lines pal,
1843: po_approval_list_headers pah
1844: WHERE pah.document_id = v_document_id
1845: and pah.document_type = v_object_type