Skip to content

SQL-004: Generate Provider Address

Returns the next identifier value used when creating provider address.

Classification

Field Value
SQL ID SQL-004
Operation type Sequence
Execution method Inline
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsProviderAddress
Criteria property CreateSQL
Lifecycle method Create

Parameters

No parameters. This statement does not accept bind input.

Tables

No tables are referenced by this SQL statement.

Sample SQL

SELECT PROVIDER_ADDRESS_SEQ_NUM_NEXTVAL FROM DUAL

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • Business\SAIF.Business.Provider\clsProviderAddress.vb