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

VIEW: AP.AP_PRODUCT_SETUP#

Object Details
Object Name: AP_PRODUCT_SETUP#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RECORD_NUMBER NUMBER
Yes
SUPPLIER_NUMBERING_METHOD VARCHAR2 (25)
SUPPLIER_NUM_TYPE VARCHAR2 (25)
NEXT_AUTO_SUPPLIER_NUM NUMBER

INVOICE_CURRENCY_CODE VARCHAR2 (15)
SUPPLIER_PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
TERMS_DATE_BASIS VARCHAR2 (25)
PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 (25)
TERMS_ID NUMBER

PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 (25) Yes
ALWAYS_TAKE_DISC_FLAG VARCHAR2 (1)
AUTO_CALCULATE_INTEREST_FLAG VARCHAR2 (1)
MATCH_OPTION VARCHAR2 (1)
HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2 (1)
USE_BANK_CHARGE_FLAG VARCHAR2 (1)
BANK_CHARGE_BEARER VARCHAR2 (1)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
Query Text

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


SELECT RECORD_NUMBER
,      SUPPLIER_NUMBERING_METHOD
,      SUPPLIER_NUM_TYPE
,      NEXT_AUTO_SUPPLIER_NUM
,      INVOICE_CURRENCY_CODE
,      SUPPLIER_PAY_GROUP_LOOKUP_CODE
,      TERMS_DATE_BASIS
,      PAY_DATE_BASIS_LOOKUP_CODE
,      TERMS_ID
,      PAYMENT_METHOD_LOOKUP_CODE
,      ALWAYS_TAKE_DISC_FLAG
,      AUTO_CALCULATE_INTEREST_FLAG
,      MATCH_OPTION
,      HOLD_UNMATCHED_INVOICES_FLAG
,      USE_BANK_CHARGE_FLAG
,      BANK_CHARGE_BEARER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM AP.AP_PRODUCT_SETUP#;

Dependencies

[top of page]

AP.AP_PRODUCT_SETUP# references the following:

SchemaAP
TableAP_PRODUCT_SETUP
AP.AP_PRODUCT_SETUP# is referenced by following:

SchemaAPPS
SynonymAP_PRODUCT_SETUP