VIEW: APPS.FV_REQUISITION_MASTER_V

Source

View Text - Preformatted

SELECT prh.org_id,prh.requisition_header_id,prl.requisition_line_id,pll.line_location_id,ph.po_header_id, suggested_vendor_name,suggested_vendor_location,ph.vendor_id,ph.vendor_site_id, prh.segment1,prh.creation_date,prh.authorization_status,prl.cancel_flag,prh.preparer_id, prl.line_num,prl.item_id,prl.category_id,prl.item_description,prl.to_person_id, prl.quantity,prl.UNIT_MEAS_LOOKUP_CODE,prl.UNIT_PRICE,prl.need_by_date FROM po_requisition_headers prh,po_requisition_lines_all prl,po_line_locations_all pll,po_headers_all ph WHERE prl.requisition_header_id = prh.requisition_header_id AND prl.line_location_id = pll.line_location_id(+) AND pll.po_header_id = ph.po_header_id(+) and prh.authorization_status = 'APPROVED'

View Text - HTML Formatted

SELECT PRH.ORG_ID
, PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PLL.LINE_LOCATION_ID
, PH.PO_HEADER_ID
, SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_LOCATION
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, PRH.SEGMENT1
, PRH.CREATION_DATE
, PRH.AUTHORIZATION_STATUS
, PRL.CANCEL_FLAG
, PRH.PREPARER_ID
, PRL.LINE_NUM
, PRL.ITEM_ID
, PRL.CATEGORY_ID
, PRL.ITEM_DESCRIPTION
, PRL.TO_PERSON_ID
, PRL.QUANTITY
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.UNIT_PRICE
, PRL.NEED_BY_DATE
FROM PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES_ALL PRL
, PO_LINE_LOCATIONS_ALL PLL
, PO_HEADERS_ALL PH
WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID(+)
AND PLL.PO_HEADER_ID = PH.PO_HEADER_ID(+)
AND PRH.AUTHORIZATION_STATUS = 'APPROVED'