[Home] [Help]
View: OF_PO_VEND_ASC_VW
Product: | GML - Process Manufacturing Logistics |
Description: | Vendor Association View |
Implementation/DBA Data: |
APPS.OF_PO_VEND_ASC_VW
|
View Text
SELECT V1.VENDOR_ID
, V2.VENDOR_ID
, 1
, V1.CREATION_DATE
, V1.LAST_UPDATE_DATE
, V1.LAST_UPDATE_LOGIN
, V1.CREATED_BY
, V1.LAST_UPDATED_BY
, 0
, NULL
, 0
, V1.PROGRAM_APPLICATION_ID
, V1.PROGRAM_ID
, V1.PROGRAM_UPDATE_DATE
, V1.REQUEST_ID
FROM PO_VEND_MST V1
, PO_VEND_MST V2
WHERE V1.VENDOR_ID != V2.VENDOR_ID
AND V1.PAYMENT_IND = 1
AND V2.SHIP_IND = 1
AND V1.DELETE_MARK = 0
AND V2.DELETE_MARK = 0
AND V1.CO_CODE = V2.CO_CODE
AND V1.OF_VENDOR_ID = V2.OF_VENDOR_ID
Columns
Name |
VEND_ID |
ASSOCVEND_ID |
ASSOC_TYPE |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
CREATED_BY |
LAST_UPDATED_BY |
DELETE_MARK |
TEXT_CODE |
TRANS_CNT |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
REQUEST_ID |