VIEW: APPS.PO_LINES_AP_V

Source

View Text - Preformatted

SELECT PL.PO_HEADER_ID PO_HEADER_ID , PL.PO_LINE_ID PO_LINE_ID , PH.VENDOR_ID VENDOR_ID , PH.APPROVED_FLAG APPROVED_FLAG , PH.CURRENCY_CODE CURRENCY_CODE , NVL(PL.LINE_NUM_DISPLAY,TO_CHAR(PL.LINE_NUM)) PO_LINE_NUM , PL.ITEM_DESCRIPTION ITEM_DESCRIPTION , PL.ORG_ID FROM PO_LINES_ALL PL, PO_HEADERS_ALL PH WHERE PL.PO_HEADER_ID = PH.PO_HEADER_ID and nvl(CLM_INFO_FLAG,'N') = 'N' and ( nvl(clm_option_indicator,'B') <> 'O' or Nvl(CLM_EXERCISED_FLAG,'N') = 'Y' )

View Text - HTML Formatted

SELECT PL.PO_HEADER_ID PO_HEADER_ID
, PL.PO_LINE_ID PO_LINE_ID
, PH.VENDOR_ID VENDOR_ID
, PH.APPROVED_FLAG APPROVED_FLAG
, PH.CURRENCY_CODE CURRENCY_CODE
, NVL(PL.LINE_NUM_DISPLAY
, TO_CHAR(PL.LINE_NUM)) PO_LINE_NUM
, PL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, PL.ORG_ID
FROM PO_LINES_ALL PL
, PO_HEADERS_ALL PH
WHERE PL.PO_HEADER_ID = PH.PO_HEADER_ID
AND NVL(CLM_INFO_FLAG
, 'N') = 'N'
AND ( NVL(CLM_OPTION_INDICATOR
, 'B') <> 'O' OR NVL(CLM_EXERCISED_FLAG
, 'N') = 'Y' )