DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.POA_PQC_BS_V

Object Details
Object Name: POA_PQC_BS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID


View that stores the Price Savings and Price Change Information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER

Operating Unit Identifier
SHIP_TO_ORG_ID NUMBER

Shipto Organization Identifier
SUPPLIER_ID NUMBER

Supplier Identifier
SUPPLIER_SITE_ID NUMBER

Supplier Site Identifier
COMMODITY_ID NUMBER

Commodity Identifier
CATEGORY_ID NUMBER

Category Identifier
PO_ITEM_ID NUMBER
Yes PO Item Identifier
BASE_UOM VARCHAR2 (25)
Base UOM
BUYER_ID NUMBER
Yes Buyer Identifier
APPROVED_DATE DATE

Approved Date
COMPANY_ID NUMBER (15)
Company Identifier
COST_CENTER_ID NUMBER (15)
Cost Center Identifier
PBCQCO_AMT_G NUMBER

Benchmark fallback Amount per OU (Global Currency)
PBCQCO_AMT_SG NUMBER

Benchmark fallback Amount per OU (Secondary Global Currency)
PBCQCO_AMT_B NUMBER

Benchmark fallback Amount per OU (Functional)
PBPCQCO_AMT_G NUMBER

Benchmark Amount per OU (Global Currency)
PBPCQCO_AMT_SG NUMBER

Benchmark Amount per OU (Secondary Global Currency)
PBPCQCO_AMT_B NUMBER

Benchmark Amount per OU (Functional Currency)
PBPCQCS_AMT_G NUMBER

Benchmark Amount per Supplier (Global Currency)
PBPCQCS_AMT_SG NUMBER

Benchmark Amount per Supplier (Global Currency)
PBPCQCS_AMT_B NUMBER

Benchmark Amount per Supplier (Secondary Global Currency)
BENCHMARKPRICE_O_G NUMBER

Benchmark Price per OU (Global Currency)
BENCHMARKPRICE_O_SG NUMBER

Benchmark Price per OU (Secondary Global Currency)
BENCHMARKPRICE_O_B NUMBER

Benchmark Price per OU (Functional)
BENCHMARKPRICE_S_G NUMBER

Benchmark Price per Supplier (Global Currency)
BENCHMARKPRICE_S_SG NUMBER

Benchmark Price per Supplier (Secondary Global Currency)
BENCHMARKPRICE_S_B NUMBER

Benchmark Price per Supplier (Functional)
PURCHASE_AMT_B NUMBER

Purchase Amount (Functional Currency)
PURCHASE_AMT_G NUMBER

Purchase Amount (Global Currency)
PURCHASE_AMT_SG NUMBER

Purchase Amount (Secondary Global Currency)
QUANTITY NUMBER

Quantity
PO_DISTRIBUTION_ID NUMBER
Yes PO Distribution Identifier
LINE_LOCATION_ID NUMBER

PO Shipment Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORG_ID
,      SHIP_TO_ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      COMMODITY_ID
,      CATEGORY_ID
,      PO_ITEM_ID
,      BASE_UOM
,      BUYER_ID
,      APPROVED_DATE
,      COMPANY_ID
,      COST_CENTER_ID
,      PBCQCO_AMT_G
,      PBCQCO_AMT_SG
,      PBCQCO_AMT_B
,      PBPCQCO_AMT_G
,      PBPCQCO_AMT_SG
,      PBPCQCO_AMT_B
,      PBPCQCS_AMT_G
,      PBPCQCS_AMT_SG
,      PBPCQCS_AMT_B
,      BENCHMARKPRICE_O_G
,      BENCHMARKPRICE_O_SG
,      BENCHMARKPRICE_O_B
,      BENCHMARKPRICE_S_G
,      BENCHMARKPRICE_S_SG
,      BENCHMARKPRICE_S_B
,      PURCHASE_AMT_B
,      PURCHASE_AMT_G
,      PURCHASE_AMT_SG
,      QUANTITY
,      PO_DISTRIBUTION_ID
,      LINE_LOCATION_ID
FROM APPS.POA_PQC_BS_V;

Dependencies

[top of page]

APPS.POA_PQC_BS_V references the following:

SchemaAPPS
TablePOA_BM_ITEM_O_MV
TablePOA_BM_ITEM_S_MV
TablePOA_PQC_BS_J_MV

APPS.POA_PQC_BS_V is not referenced by any database object