APPS.PO_WF_REQ_NOTIFICATION_R11 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 791: hr_locations hrt,

787: rql.suggested_vendor_name,
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

Line 818: hr_locations hrt,

814: per.full_name,
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

Line 1059: hr_locations hrt,

1055: rql.suggested_vendor_name,
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

Line 1086: hr_locations hrt,

1082: per.full_name,
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