Explore topic-wise InterviewSolutions in .

ADDING COLUMN to EXISTING table

Adding column to existing table

• CREATETS
• MODIFY
• CREATE USERID
• MODIFY USERID

KEY or any NUMERIC DATA TYPE

KEY or any numeric data type

• GET
• getList
• DELETE
• UPDATE
• INSERT

A METHOD of fulfilling sales ORDERS by selling products without handling, stocking,or delivering them. The selling company buys a product from a SUPPLIER and has the supplier ship the product DIRECTLY to customers.

A method of fulfilling sales orders by selling products without handling, stocking,or delivering them. The selling company buys a product from a supplier and has the supplier ship the product directly to customers.

A user-defined set of CRITERIA to DEFINE the priorities Order Management use when picking ITEMS out of finished goods inventory to SHIP to a customer. Picking rules are defined in Oracle Inventory.

A user-defined set of criteria to define the priorities Order Management use when picking items out of finished goods inventory to ship to a customer. Picking rules are defined in Oracle Inventory.

Price list CONTAINS information on items and its PRICES. The pricing engine USES SECONDARY price lists when it cannot determine the price for an item using the price list assigned to an order.

Price list contains information on items and its prices. The pricing engine uses secondary price lists when it cannot determine the price for an item using the price list assigned to an order.

YIFApi INTERFACE does not EXTEND APIs for custom/hang-off tables. Therefore, the APIs for these tables MUST be CONFIGURED as services.

YIFApi interface does not extend APIs for custom/hang-off tables. Therefore, the APIs for these tables must be configured as services.

PURCHASE Order: The DOCUMENT which is CREATED and sent to supplier when we need to purchase something. (Buying)Sales Order: The document which is created when CUSTOMER places an order to buy something.

Purchase Order: The document which is created and sent to supplier when we need to purchase something. (Buying)Sales Order: The document which is created when customer places an order to buy something.

PICK slip is a shipping document that the pickers USE to locate ITEMS in the WAREHOUSE/ inventory to ship for an order.

Pick slip is a shipping document that the pickers use to locate items in the warehouse/ inventory to ship for an order.

Processing Constraints allow Order MANAGEMENT users the ability to control changes to SALES ORDERS, at all stages of its order or LINE WORKFLOWS to avoid data inconsistencies and audit problems.

Processing Constraints allow Order Management users the ability to control changes to sales orders, at all stages of its order or line workflows to avoid data inconsistencies and audit problems.

A CUSTOM table is an independent table and cannot be MODELED as an EXTENSION to a standard application DATABASE table.

A custom table is an independent table and cannot be modeled as an extension to a standard application database table.