View: CE_PO_FC_REQUISITIONS_TEMP_V

Product:	CE - Cash Management
Description:	Forecasting source - temp labor PO requisitions
Implementation/DBA Data:	APPS.CE_PO_FC_REQUISITIONS_TEMP_V

View Text

SELECT PRH.SEGMENT1
, /* 1 */ NVL(PRD.REQ_LINE_AMOUNT
, 0)
, /* 2 */ NVL(PRD.REQ_LINE_CURRENCY_AMOUNT
, 0) + NVL(PRD.NONRECOVERABLE_TAX
, 0)
, /* 3 */ NVL(NVL(PRL.CURRENCY_CODE
, FSP.INVOICE_CURRENCY_CODE)
, SOB.CURRENCY_CODE)
, /* 4 */ PRL.ASSIGNMENT_START_DATE
, /* 5 */ PRL.ASSIGNMENT_END_DATE
, /* 6 */ NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
, /* 7 */ PRL.ORG_ID
, /* 8 */ PRD.PROJECT_ID
, /* 9 */ PRL.LINE_NUM
, /* 10 */ PRD.DISTRIBUTION_ID
, /* 11 */ PRL.ORDER_TYPE_LOOKUP_CODE
, /* 12 */ PRL.PURCHASE_BASIS
, /* 13 */ PRL.MATCHING_BASIS /* 14 */ FROM PO_DOCUMENT_TYPES_ALL PDT
, PO_REQ_DISTRIBUTIONS_ALL PRD
, PO_REQUISITION_LINES_ALL PRL
, PO_REQUISITION_HEADERS_ALL PRH
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, GL_SETS_OF_BOOKS SOB
WHERE FSP.SET_OF_BOOKS_ID = PRD.SET_OF_BOOKS_ID AND (FSP.ORG_ID = PRD.ORG_ID OR FSP.ORG_ID IS NULL)
AND SOB.SET_OF_BOOKS_ID = PRD.SET_OF_BOOKS_ID AND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID AND (PRH.ORG_ID = PRL.ORG_ID OR PRH.ORG_ID IS NULL) AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID AND (PRH.ORG_ID = PDT.ORG_ID OR PRH.ORG_ID IS NULL) AND PRH.TYPE_LOOKUP_CODE = 'PURCHASE' AND PRH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE AND PDT.DOCUMENT_TYPE_CODE = 'REQUISITION' AND PRH.AUTHORIZATION_STATUS NOT IN ('CANCELLED'
, 'REJECTED') AND NVL(PRL.CLOSED_CODE
, 'APPROVED') NOT IN ('CANCELLED'
, 'FROZEN'
, 'FINALLY CLOSED') AND PRL.SOURCE_TYPE_CODE = 'VENDOR' AND PRL.LINE_LOCATION_ID IS NULL AND NVL(PRL.MODIFIED_BY_AGENT_FLAG
, 'N') = 'N' AND NVL(PRL.CANCEL_FLAG
, 'N') = 'N'
AND PRL.PURCHASE_BASIS ='TEMP LABOR'

Columns