Buy One Get other item Free

Promotions

Lets create a promotional setup in Advance pricing for "Buy One Get other item free or get 50% discount on other Item"

 Steps

Create 2 item "Test Item” and "Free Item".

 Enter both items in Price list with price as 1000 for both of them

Now Navigate to Modifier> Modifier setups and enter header information Like type as Promotion, Currency as USD, enter any number you like and check Active and Automatic. Optionally you can provide start and end dates

↑  Now enter line level information. Modifier number will come automatically. Select Type as Promotional Goods

Pricing Phase as "List Line Adjustment" and select product attribute value as "TEST Item" and as this is recurring discount so you can select Break type as Recurring. Values are between 1 to 10 only ie. if order qty is between these values only then item this modifier is applicable

Now click on Define Details

 in this under Get please enter free Item details. Application method is percent and give value as 100% i.e. its totally free. if you provide the value as 50% i.e. that means there is 50% discount on second item

save you work

 Run "QP: Maintains the denormalized data in QP Qualifiers".

Enter a sales order for Test Item.

When you save the Sales order, you will get a message that a new line has been added for free item

Click OK

same way if you specify 50% value in Define Details, customer will get 50% discount on second item. 

Go to sales order add one more line with ''TEST Item''

now save the record ,you will get a message that a new line has been added  

''Free item'' add
with 50% discount 

Tables Joins in Oracle apps WIP, BOM, INV

Tables Joins in Oracle apps WIP, BOM, INV

1) BOM :

BOM_RESOURCES 

BOM_BILL_OF_MATERIALS 

BOM_DEPARTMENTS (BD)

BOM_OPERATIONAL_ROUTINGS 

BOM_OPERATION_SEQUENCES 

BOM_INVENTORY_COMPONENTS 

BOM_STANDARD_OPERATIONS 

2) INV : 

MTL_PARAMETERS 

MTL_SYSTEM_ITEMS_B 

MTL_MATERIAL_TRANSACTION 

MTL_SERIAL_NUMBERS 

MTL_ITEM_REVISIONS 

MTL_ITEM_CATEGORIES 

MTL_DEMAND 

MTL_TRANSACTION_TYPES 

MTL_CATEGORIES 

CST_ITEM_COSTS 

CST_COST_ELEMENTS 

3) WIP :

WIP_PARAMETERS 

WIP_DISCRETE_JOBS 

WIP_ENTITIES 

WIP_OPERATIONS 

WIP_REQUIREMENT_OPERATIONS 

WIP_OPERATION_RESOURCES 

WIP_TRANSACTIONS 

WIP_TRANSACTION_ACCOUNTS 

WIP_LINES 

WIP_EAM_WORK_REQUESTS 

WIP_EAM_PARAMETERS 

1) JOINS IN BOM and BOM-INV

BOM_BILL_OF_MATERIALS (BBOM)                       MTL_SYSTEM_ITEMS_B (MSIB)

organization_id                                                                  organization_id

assembly_item_id                                                              inventory_item_id

MTL_SYSTEM_ITEMS_B (MSIB)                                BOM_OPERATIONAL_ROUTINGS (BOR)

inventory_item_id                                                              assembly_item_id

organization_id                                                                  organization_id

BOM_BILL_OF_MATERIALS (BBOM)                       BOM_INVENTORY_COMPONENTS (BIC)

bill_sequence_id                                                                bill_sequence_id

BOM_INVENTORY_COMPONENTS (BIC)               MTL_SYSTEM_ITEMS_B (MSIB)

component_item_id                                                           inventory_item_id

BOM_OPERATIONAL_ROUTINGS(BOR)                  BOM_OPERATION_SEQUENCES(BOS)

routing_sequence_id                                                          routing_sequence_id

BOM_OPERATION_SEQUENCES (BOS)                   BOM_STANDARD_OPERATIONS (BSO)

standard_operation_id                                                       standard_operation_id

BOM_OPEARATION_SEQUENCES(BOS)                  BOM_DEPARTMENTS (BD)

department_id                                                                   department_id

BOM_DEPARTMENTS (BD)                                        BOM_DEPARTMENT_CLASSES

department_id                                                                   department_id

operation_sequence_id                                                      operation_sequence_id

BOM_OPERATION_RESOURCE (BORE)                   BOM_RESOURCES (BR)

resource_id                                                                       resource_id

BOM_DEPARMTENTS (BD)                                         BOM_RESOURCES (BR)

organization_id                                                                  organization_id 

2) JOINS IN INV :

MTL_SYSTEM_ITEMS_B (MSIB)                                 MTL_PARAMETERS (MP)

organization_id                                                                   organization_id

MTL_MATERIAL_TRANSACTION (MMT)                 MTL_TRANSACTION_TYPES (MTT)

transaction_type_id                                                            transaction_type_id

MTL_MATERIAL_TRANSACTION (MMT)                 MTL_ITEM_CATEGORIES (MIC)

organization_id                                                                  organization_id

inventory_item_id                                                              inventory_item_id

MTL_MATERIAL_TRANSACTION (MMT)                MTL_SYSTEM_ITEMS_B(MSIB)

inventory_item_id                                                              inventory_item_id

MTL_TRANSACTION_TYPES (MTT)                         MTL_SYSTEM_ITEMS_B(MSIB)

inventory_item_id                                                              inventory_item_id

MTL_ITEM_REVISIONS(MIR)                                     MTL_SYSTEM_ITEMS_B(MSIB)

inventory_item_id                                                              inventory_item_id

organization_id                                                                  organization_id

CST_ITEM_COSTS(CIC)                                              MTL_SYSTEM_ITEMS_B(MSIB)

inventory_item_id                                                              inventory_item_id

organization_id                                                                  organization_id

MTL_ITEM_CATEGORIES (MIC)                                MTL_CATEGORIES (MC)

category_id                                                                       category_id

JOINS IN INV WITH OTHER MODULES :

MTL_SYSTEM_ITEMS_B (MSIB)                                 RCV_TRANSACTIONS (RT)

organization_id                                                                  organization_id

MTL_SYSTEM_ITEMS_B (MSIB)                                 HR_EMPLOYEES (HE)

buyer_id                                                                            employee_id

3) JOINS IN WIP :

WIP_ENTITIES (WE)                                                     WIP_TRANSACTIONS (WT)

organization_id                                                                  organization_id

wip_entity_id                                                                     wip_entity_id

WIP_TRANSACTION_ACCOUNTS (WTA)                WIP_TRANSACTIONS (WT)

transaction_id                                                                    transaction_id

WIP_LINES (WL)                                                           WIP_TRANSACTIONS(WT)

line_id                                                                                line_id

WIP_DISCRETE_JOBS (WDJ)                                       WIP_ENTITIES (WE)

wip_entity_id                                                                      wip_entity_id

WIP_ENTITIES (WE)                                                       WIP_OPERATION_RESOURCES (WOR)

wip_entity_id                                                                       wip_entity_id

WIP_ENTITIES (WE)                                                     WIP_REQUIREMENT_OPERATIONS

organization_id                                                                    organization_id

WIP_ENTITIES                                                                 WIP_OPERATIONS

wip_entity_id                                                                       wip_entity_id

organization_id                                                                    organization_id

JOINS IN WIP WITH OTHER MODULES

WIP_TRANSACTION_ACCOUNTS (WTA)               PO_HEADERS_ALL (PHA)

po_header_id                                                                   po_header_id

CST_COST_ELEMENTS (CCE)                                   WIP_TRANSACTION (WT)

cst_element_id                                                                 cst_element_id

WIP_OPERATIONS (WO)                                            BOM_DEPARTMENTS (BD)

department_id                                                                  department_id

WIP_ENTITIES (WE)                                                     MTL_SYSTEM_ITEMS_B (MSIB)

organization_id                                                                  organization_id

primary_item_id                                                                inventory_item_id

WIP_OPERATION_RESOURCES (WOR)                    BOM_RESOURCES (BR)

resource_id                                                                       resource_id

Inventory Key   Tables     Table Definitions MTL_SYSTEM_ITEMS_B This table holds the definitions for inventory items, engineering items, and purchasing items. The primary key for an item is the INVENTORY_ITEM_ID and ORGANIZATION_ID.     MTL_ITEM_STATUS This is the definition table for material status codes. Status code is a required item attribute. It indicates the status of an item, i.e., Active, Pending, Obsolete.         MTL_UNITS_OF_MEASURE_TL This is the definition table for both the 25-character and the 3-character units of measure. The base_uom_flag indicates if the unit of measure is the primary unit of measure for the uom_class. Oracle Inventory uses this table to keep track of the units of measure used to transact an item.         MTL_ITEM_LOCATIONS This is the definition table for stock locators. The associated attributes describe which subinventory this locator belongs to, what the locator physical capacity is, etc.         MTL_ITEM_CATEGORIES This table stores inventory item assignments to categories within a category set.         MTL_CATEGORIES_B This is the code combinations table for item categories.         MTL_CATEGORIES_B and MTL_CATEGORIES_TL. MTL_CATEGORIES_TL table holds translated Description for Categories.         MTL_CATEGORY_SETS_B  It contains the entity definition for category sets.     MTL_DEMAND  This table stores demand and reservation information used in Available To Promise, Planning and other Manufacturing functions. There are three major row types stored in the table: Summary Demand rows,Open Demand Rows, and Reservation Rows.         MTL_SECONDARY_INVENTORIES This is the definition table for the subinventory.         MTL_ONHAND_QUANTITIES  It stores quantity on hand information by control level and location.         MTL_TRANSACTION_TYPES It contains seeded transaction types and the user defined ones.         MTL_MATERIAL_TRANSACTIONS This table stores a record of every material transaction or cost update performed in Inventory.         MTL_ITEM_ATTRIBUTES  This table stores information on item attributes.         MTL_ITEM_CATALOG_GROUPS_B  This is the code combinations table for item catalog groups.         MTL_ITEM_REVISIONS_B  It stores revision levels for an inventory item.         MTL_CUSTOMER_ITEMS It stores customer item information for a specific customer. Each record can be defined at one of the following levels: Customer, Address Category, and Address. The customer item definition is organization independent.         MTL_SYSTEM_ITEMS_INTERFACE It temporarily stores the definitions for inventory items, engineering items and purchasing items before loading this information into Oracle Inventory.         MTL_TRANSACTIONS_INTERFACE  It allows calling applications to post material transactions (movements, issues, receipts etc. to Oracle Inventory  transaction module.         MTL_ITEM_REVISIONS_INTERFACE It temporarily stores revision levels for an inventory item before loading this information into Oracle Inventory.         MTL_ITEM_CATEGORIES_INTERFACE  This table temporarily stores data about inventory item assignments to category sets and categories before loading this information into Oracle Inventory.         MTL_DEMAND_INTERFACE  It is the interface point between non-Inventory applications and the Inventory demand module. Records inserted into this table are processed by the Demand Manager concurrent program.         MTL_INTERFACE_ERRORS  It stores errors that occur during the item interface process reporting where the errors occurred along with the error messages.         MTL_PARAMETERS It maintains a set of default options like general ledger accounts; locator, lot, and serial controls, inter-organization options, costing method, etc. for each organization defined in Oracle Inventory.Each organization’s item master organization (MASTER_ORGANIZATION_ID) and costing organization (COST_ORGANIZATION_ID) are maintained here.         RCV_TRANSACTIONS It stores historical information about receiving transactions that you have performed. When you enter a receiving transaction and the receiving transaction processor processes your transaction, the transaction is recorded in this table         RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES When a Ship Confirm is processed, one record is inserted in rcv_shipment_headers and one record is inserted in rcv_shipment_lines for each of the Sales Order Lines. The rcv_shipment_lines are linked to the one rcv_shipment_header record by shipment_header_id.             MTL_ITEM_TEMPLATES_B This is the definition table for item templates. It   contains the user-defined name (TEMPLATE_NAME) and description (DESCRIPTION) .You can use a template to set certain item attributes.     ORG_ACCT_PERIODS It holds the open and closed financial periods for organizations.     MTL_DESCRIPTIVE_ELEMENTS It stores the descriptive element definitions for an item catalog group. Descriptive elements are defining properties used to describe in the catalog group.         MTL_DESCR_ELEMENT_VALUES It stores the descriptive element values for a specific item. When an item is associated with a particular item catalog group, one row per descriptive element (for that catalog group) is inserted into this table.         MTL_ABC_CLASSES MTL_ABC_CLASSES contains information about ABC Classes. Each row in this table defines an ABC Class.         MTL_ABC_COMPILES MTL_ABC_COMPILES stores information about each item within an ABC compile.          MTL_CC_SERIAL_NUMBERS This table is used to store serial numbers associated to a cycle count entry involving a serialized item.          MTL_CC_SUBINVENTORIES MTL_CC_SUBINVENTORIES stores all the subinventories that are to be considered for cycle counting when the scope of the cycle count is at subinventory level.          MTL_CROSS_REFERENCES MTL_CROSS_REFERENCES is used to assign cross-references to items. The cross reference type code identifies the cross-referencing identification system being used.          MTL_CROSS_REFERENCE_TYPES MTL_CROSS_REFERENCE_TYPES is used to define cross-reference types.         MTL_DEFAULT_CATEGORY_SETS MTL_DEFAULT_CATEGORY_SETS stores the identifier of the category set that acts as the default for a particular functional area.         MTL_ITEM_LOC_DEFAULTS MTL_ITEM_LOC_DEFAULTS contains the optional default locators for shipping and receivingpurposes.          MTL_ITEM_SUB_DEFAULTS MTL_ITEM_SUB_DEFAULTS contains the list of optional default shipping and receiving subinventories for items in an organization.          MTL_ITEM_SUB_INVENTORIES MTL_ITEM_SUB_INVENTORIES maintains a listing of subinventories assigned to an inventory or engineering item.         MTL_ITEM_TEMPLATES MTL_ITEM_TEMPLATES is the definition table for item templates. It contains the user-defined name (TEMPLATE_NAME) and description (DESCRIPTION).         MTL_ITEM_TEMPL_ATTRIBUTES MTL_ITEM_TEMPL_ATTRIBUTES stores the attributes and attribute values for item templates.          MTL_LOT_NUMBERS MTL_LOT_NUMBERS stores the definition and expiration date of all lot numbers in inventory.         MTL_MATERIAL_STATUSES_B MTL_MATERIAL_STATUSES_B is the base table for the inventory statuses.          MTL_TXN_REQUEST_HEADERS This table stores all of the move order headers.         MTL_TXN_REQUEST_LINES The table MTL_TXN_REQUEST_LINES stores all of the move order lines.         MTL_RESERVATIONS This table stores reservation information. Each record is a reservation that ties an item/organization combination with a demand source and a supply source.          MTL_SALES_ORDERS MTL_SALES_ORDERS stores Inventory's local definition of sales orders.     MTL_SECONDARY_INVENTORIES MTL_SECONDARY_INVENTORIES is the definition table for the subinventory.      MTL_SERIAL_NUMBERS MTL_SERIAL_NUMBERS stores the definition and current status of all serial numbers in Oracle Inventory. These serial numbers are also used in other areas of Oracle Manufacturing.A serial number can have one of four statuses: - Defined but not used - Resides in stores - Issued out of stores - Resides in intransit           MTL_RELATED_ITEMS Table containing items that can be substitute to an item if the original item is out of stock     MTL_GENERIC_DISPOSITIONS Account Alias table     MTL_ABC_ASSIGNMENT_GROUPS ABC     MTL_ABC_ASSGN_GROUP_CLASSES ABC Classification table         MTL_ABC_CLASSES ABC Classes with value of each item based on criteria in ABC Assignment     MTL_UNITS_OF_MEASURE UOM used for Item         MTL_MANUFACTURERS Manufacturers table for an item         MTL_CATEGORIES_KFV Categories Flexfield     MTL_CATEGORY_SETS Category Sets which contains the structure of flexfield     MTL_UOM_CONVERSIONS conversion table based on UOM     MTL_TRANSACTION_ACCOUNTS Accounting Distribution for Material Transactions         MTL_TRANSACTION_SOURCE_TYPES Source of Material Transactions         CST_ITEM_COSTS Standard Cost Tables         CST_ITEM_COST_DETAILS Standard Cost Detail Table     CST_COST_TYPES Types of Costing as used in Material Transaction Costing     ORG_ORGANIZATION_DEFINITIONS Organization Information used in Inventory         MTL_SERIAL_NUMBERS_INTERFACE Stores the serial number of an item for transactions         MTL_TRANSACTION_LOTS_INTERFACE Interface for transaction of item with lot controlled         MTL_CROSS_REFERENCES_INTERFACE Cross References Interface         MTL_ITEM_REVISIONS_INTERFACE Revision of Item in terms of changes from ECO for example     MTL_MATERIAL_TRANSACTIONS_TEMP Temporary table for processing material transactions      MTL_TRANSACTION_REASONS Inventory Transaction Reasons .     MTL_TRANSACTION_LOTS_TEMP Temporary lot numbers holding table     MTL_CATEGORY_SET_VALID_CATS Valid categories for category sets