View: ITG_SP_PO_POTERM_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used to generate the PO terms segment of the XML for Sync PO
Implementation/DBA Data:	APPS.ITG_SP_PO_POTERM_V

View Text

SELECT PHA.PO_HEADER_ID
, PHA.TERMS_ID
, TERMS.DESCRIPTION
, TERMS.NAME TERMID
, TO_CHAR(TERMLINES.DUE_DAY_OF_MONTH) DAYOFMONTH
, TO_CHAR(TERMLINES.DUE_MONTHS_FORWARD) PROXMONTH
, TERMLINES.DUE_AMOUNT OPERAMT
FROM AP_TERMS TERMS
, AP_TERMS_LINES TERMLINES
, PO_HEADERS_ALL PHA
WHERE TERMS.TERM_ID (+) = PHA.TERMS_ID
AND TERMLINES.TERM_ID (+) = PHA.TERMS_ID

Columns