55: quantity po_requisition_lines.quantity%TYPE,
56: unit_price po_requisition_lines.unit_price%TYPE,
57: line_amount NUMBER,
58: need_by_date po_requisition_lines.need_by_date%TYPE,
59: location hr_locations.location_code%TYPE,
60: requestor per_people_f.full_name%TYPE,
61: sugg_supplier po_requisition_lines.suggested_vendor_name%TYPE,
62: sugg_site po_requisition_lines.suggested_vendor_location%TYPE,
63: txn_curr_code po_requisition_lines.currency_code%TYPE,
1198: */
1199:
1200: -- bug4963032
1201: -- Modified sql for better performance. Changes include:
1202: -- 1) Use hr_locations_all instead of hr_locations
1203: -- 2) the join between rql.destinatino_organization_id and msi.organization_id
1204: -- becomes an outer join
1205:
1206: CURSOR line_csr(v_document_id NUMBER) IS
1222: rql.currency_code,
1223: rql.currency_unit_price
1224: FROM po_requisition_lines rql,
1225: mtl_system_items_kfv msi,
1226: hr_locations_all hrt,
1227: mtl_units_of_measure muom, -- bug 2401933.add
1228: per_all_people_f per -- Bug 3404451
1229: WHERE rql.requisition_header_id = v_document_id
1230: AND NVL(rql.cancel_flag,'N') = 'N'
1450: */
1451:
1452: -- bug4963032
1453: -- Modified sql for better performance. Changes include:
1454: -- 1) Use hr_locations_all instead of hr_locations
1455: -- 2) the join between rql.destinatino_organization_id and msi.organization_id
1456: -- becomes an outer join
1457:
1458:
1475: rql.currency_code,
1476: rql.currency_unit_price
1477: FROM po_requisition_lines rql,
1478: mtl_system_items_kfv msi,
1479: hr_locations_all hrt,
1480: per_all_people_f per, -- Bug 3404451
1481: mtl_units_of_measure muom, -- bug 2401933.add
1482: org_organization_definitions org
1483: WHERE rql.requisition_header_id = v_document_id