[Home] [Help]
View: PO_TEMP_LABOR_HEADERS_V
Product: | PO - Purchasing |
Description: | Retrieves information on approved standard POs with Temp Labor lines. |
Implementation/DBA Data: |
APPS.PO_TEMP_LABOR_HEADERS_V
|
View Text
SELECT POH.SEGMENT1 PO_NUMBER
, HROUTL.NAME OPERATING_UNIT_NAME
, HROU.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PDT.TYPE_NAME PO_TYPE
, PLC.DISPLAYED_FIELD AUTHORIZATION_STATUS_DSP
, POH.PO_HEADER_ID PO_HEADER_ID
, POH.VENDOR_ID VENDOR_ID
, POH.VENDOR_SITE_ID VENDOR_SITE_ID
, PV.VENDOR_NAME VENDOR_NAME
, PVS.VENDOR_SITE_CODE VENDOR_SITE_NAME
, POH.AGENT_ID BUYER_ID
, PER.FULL_NAME BUYER_FULL_NAME
FROM PO_HEADERS_ALL POH
, HR_ALL_ORGANIZATION_UNITS HROU
, HR_ALL_ORGANIZATION_UNITS_TL HROUTL
, PER_ALL_PEOPLE_F PER
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, PO_LOOKUP_CODES PLC
, PO_DOCUMENT_TYPES_ALL_TL PDT
WHERE POH.TYPE_LOOKUP_CODE = 'STANDARD'
AND POH.AUTHORIZATION_STATUS IN ('APPROVED'
, 'PRE-APPROVED')
AND POH.APPROVED_FLAG = 'Y'
AND POH.ENABLED_FLAG = 'Y'
AND NVL(POH.CANCEL_FLAG
, 'N') <> 'Y'
AND NVL(POH.FROZEN_FLAG
, 'N') <> 'Y'
AND POH.ORG_ID IS NOT NULL
AND POH.ORG_ID = HROU.ORGANIZATION_ID
AND HROU.ORGANIZATION_ID = HROUTL.ORGANIZATION_ID
AND HROUTL.LANGUAGE = USERENV('LANG')
AND POH.AGENT_ID = PER.PERSON_ID
AND PER.EFFECTIVE_START_DATE = (SELECT MAX(PER1.EFFECTIVE_START_DATE)
FROM PER_ALL_PEOPLE_F PER1
WHERE PER.PERSON_ID = PER1.PERSON_ID)
AND POH.VENDOR_ID = PV.VENDOR_ID
AND POH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND POH.ORG_ID = PVS.ORG_ID
AND PLC.LOOKUP_CODE (+) = POH.AUTHORIZATION_STATUS
AND PLC.LOOKUP_TYPE (+) = 'AUTHORIZATION STATUS'
AND PDT.DOCUMENT_TYPE_CODE = 'PO'
AND PDT.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND PDT.ORG_ID = POH.ORG_ID
AND PDT.LANGUAGE = USERENV('LANG')
AND EXISTS (SELECT NULL
FROM PO_LINES_ALL POL
, PO_LINE_TYPES_B POLT
WHERE POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND NVL(POL.CANCEL_FLAG
, 'N') <> 'Y'
AND POL.LINE_TYPE_ID = POLT.LINE_TYPE_ID
AND POLT.PURCHASE_BASIS = 'TEMP LABOR')
Columns
Name |
PO_NUMBER |
OPERATING_UNIT_NAME |
BUSINESS_GROUP_ID |
PO_TYPE |
AUTHORIZATION_STATUS_DSP |
PO_HEADER_ID |
VENDOR_ID |
VENDOR_SITE_ID |
VENDOR_NAME |
VENDOR_SITE_NAME |
BUYER_ID |
BUYER_FULL_NAME |