DBA Data[Home] [Help]

APPS.PO_WF_DOCUMENT dependencies on HR_LOCATIONS

Line 15: location hr_locations.location_code%TYPE,

11: quantity po_requisition_lines.quantity%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:

Line 894: hr_locations hrt,

890: rql.suggested_vendor_name,
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(+)