[Home] [Help] [Dependency Information]
Object Name: | PO_TEMP_LABOR_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.PO_TEMP_LABOR_HEADERS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_NUMBER | VARCHAR2 | (20) | Yes | PO number |
OPERATING_UNIT_NAME | VARCHAR2 | (240) | Yes | Name of the Purchasing Operating Unit for this PO |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Identifier for the business group that the Purchasing Operating Unit belongs to |
PO_TYPE | VARCHAR2 | (80) | Yes | Display name for the type of the PO |
AUTHORIZATION_STATUS_DSP | VARCHAR2 | (80) | Display name for the authorization status of the PO | |
PO_HEADER_ID | NUMBER | Yes | Identifier for the PO header | |
VENDOR_ID | NUMBER | Identifier for the supplier | ||
VENDOR_SITE_ID | NUMBER | Identifier for the supplier site | ||
VENDOR_NAME | VARCHAR2 | (240) | Display name for the supplier | |
VENDOR_SITE_NAME | VARCHAR2 | (15) | Display name for the supplier site | |
BUYER_ID | NUMBER | (9) | Yes | Identifier for the buyer on the PO |
BUYER_FULL_NAME | VARCHAR2 | (240) | Full name of the buyer on the PO |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.PO_TEMP_LABOR_HEADERS_V;
|
|
|