PO_SUPPLIERS_VAL_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: PO
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SEGMENT1 VAT_REGISTRATION_NUM TYPE_1099 VENDOR_ID SHIP_TO_LOCATION_ID BILL_TO_LOCATION_ID FOB_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE VAT_CODE |
問合せ
| SQL_Statement |
|---|
|
SELECT POV.SEGMENT1, POV.VAT_REGISTRATION_NUM, POV.TYPE_1099, POV.VENDOR_ID, NULL SHIP_TO_LOCATION_ID , NULL BILL_TO_LOCATION_ID, NULL FOB_LOOKUP_CODE, NULL FREIGHT_TERMS_LOOKUP_CODE , NULL VAT_CODE FROM POZ_SUPPLIERS POV WHERE POV.ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(POV.START_DATE_ACTIVE, SYSDATE-1) AND NVL(POV.END_DATE_ACTIVE, SYSDATE+1) |