Inventory Transactions
_______________________
/*In oracle Applications, the hierarchy of org's is given below.
Set of Books => Legal Entities => Operating Units => Inventory Organization.
The Set of Books is defined in the General Ledger application setups, Legal Entity
is defined in the HR while the Operating Units and Inventory Organization
(organization) are defined in the Inventory App.
In Inventory, the items are stored in different subinventories, locations etc.
We can find what are all the subinventories that are available in the systems.
Generally we define subinventories corresponding to an inventory organization
and one inventory organization will have several subinventories associated
with it.(setup=>subinventories)
*/
SELECT secondary_inventory_name,description, organization_id,location_id ,a.*
FROM mtl_secondary_inventories a
WHERE secondary_inventory_name LIKE 'MY%'
--select * from mtl_physical_inventories , mtl_physical_subinventories
/* We can define the locations that these subinventories will be physically located
using the setup And associate these locations to a particular sub inventory,it
can be seen from above query. */
SELECT location_code, location_use, description descr,ship_to_Location_id,
ship_to_site_flag,inventory_organization_id
FROM hr_locations
WHERE location_code LIKE 'MY%'
/* The different types of transactions that are available in Inventory are given
below.They are like
Subinventory Transfer,
Move Order,
Container Pack etc.
A transaction type is a combination of transaction
source type and transaction action. We can have a user-defined transaction
source types, but there are a predefined set of transaction actions(a user cannot
define anymore tranasction actions). So based on a pre-defined transaction actions
and source types, we have some predefined transaction types. However if we need to
have a new transaction type(apart from already provided ones), we have to create a
new transaction source type, and create a new transaction type based on the new
transaction source type and associating it with a any of the existing transaction
actions.
Ex's of transaction action is "Issue from Stores", "Receipt into Stores" etc.
Ex of a predefined txn source type is "Sales Order ".
So based on these two, the predefined transaction type is "Sales Order Issue".
Another ex is we can have a predefined source type as "Goodwill" and transaction
action is "Issue from Stores" and Transaction type is "Goodwill Donation".
One more ex is transaction type "Subinventory Transfer" which corresponds to the
transaction action "Subinventory Transfer".
*/
SELECT transaction_type_name, transaction_source_type_id, status_control_flag
FROM mtl_transaction_types
ORDER BY 1
SELECT transaction_source_type_id, transaction_source_type_name, description
FROM mtl_txn_source_types
ORDER BY 1
/* So we can see that items can participate in different kinds of transactions like
"Issue from stores" in which case they go out to the sales order, "Receipt into Stores"
coming into the inventory, moving across the subinventory which is called subinventory
transfer etc. So all these transactions are stored in the table mtl_material_transactions.
So given a item name, we can always find out in all the transactions that this item
has participated in, by using the following query. So all these transactions are called
Item Transactions or Material Transactions. It is interesting to see that the item's
transaction quantity having a negative balance as well as positive balance.*/
*/
SELECT transaction_quantity, inventory_item_id,subinventory_code,source_code,
transaction_type_id, transaction_action_id, transaction_source_type_id
FROM mtl_material_transactions
WHERE inventory_item_id =(SELECT inventory_item_id FROM mtl_system_items_b
WHERE organization_id= 1 AND segment1='CISCO TEST ITEM1'
)
/* Move Orders :- Move Orders are requests for the movement of material within
a single inventory organization. This will allow planners and facility managers
to request the movement of material within the warehouse/facility for purposes
like Replenishment, Material storage relocations and Quality Handling.
Move Orders are restricted to only with in inventory organizations, and if you
want to move out of an organization, then we have to use the internal requisition process.
Oracle provides for 3 types of Move Orders
Move Order Requisitions :: Manually generated request for Move Order.
Replenishment Move Order:: ex Preapproved automatic move order which can happen when a minimum quantity is
reached in inventory.
Pick Wave Move Order :: Preapproved requests for subinventory transfers to bring material from a source
location to a staging subinventory.
The Move Order type refers to the entity that created the Move Order. For all Move orders the final result is
either Subinventory Transfer or Account Process. Move Orders use Inventory picking rules to suggest
source location, lot number, revisions for the material to be picked.
So out of the 3 different move order types, two of them are typically pre-approved move orders while the
Move order requisition is a manual move order,which we can allocate and transact it manually.
The different steps that a move order will go thru are given below.
Move Order Creation.
Move Order Approval.
Move Order Allocation => At this stage, the Inventory will use picking rules defined to allocate the
Material to this particular Move order.At this point the material reservation is made.
that is we can check the information in the table mtl_reservations.
In this step, it will fill all the details like the from and to subinventory,but does not
actually execute those steps.
Print Pick Slip (optional) => This is an optional step to print the pick slip.
Move Order Transaction. => Typically each Move order will consist of a header and lines. Each line
will correspond to an item. We can transact one line at a time or all together.
Now at this point the actual subinventory transfer will happen. That is we can see the records
in the material transaction mtl_material_transactions.
*/
/* Generally quantities of items are stored in subinventories corresponding to
an organization. An org can get a material qty from a transaction which can either
be a purchase , movement from another subinventory, manufactured etc. If we have
any material transaction like subinventory transfer of any particular item also
we can see that from this query. */
SELECT b.inventory_item_id item_id, b.organization_id org, b.segment1 item_code,
a.transaction_quantity, subinventory_code subinvt, cost_group_id
FROM mtl_onhand_quantities_detail a, mtl_system_items_b b
WHERE a.organization_id = b.organization_id
AND a.inventory_item_id = b.inventory_item_id
AND b.segment1 = 'CISCO TEST ITEM1'
-- Givena a item code, query will give the organization name.
SELECT inventory_item_id, a.organization_id , b.name
FROM mtl_system_items a, hr_organization_units b
WHERE segment1='MARUTI 4000'
AND a.organization_id = b.organization_id --707983616
-- Given a item , we can find all the orders which have placed an order on these items
SELECT header_id, line_id
FROM oe_order_lines_all
WHERE ordered_item='MARUTI 4000'
/* An Item onhand quantity is the total quantity of that item. We can see that
quantity in the mtl_onhand_quantities_detail table. Out of this amount, we can
place reservations for that item either on the order line itself or we can even
go to the Inventory and do this. In the latter case, we choose the "Reservations"
form to place a reservation on this item. Incidentally we need to provide the
order number and the line number which has this item, which creates a reservation
on that item. In that case, the data goes into the mtl_reservations table. Hence
the available quantity of any item is onhand minus the reserved quantity. So the
formula is
onfiltered= Reserved + Available (to transact, reserve or sell).
The below query will also give you the order line id (demand source line id) of an order which has placed
the reservation. */
SELECT demand_source_header_id, demand_source_line_id,reservation_quantity
,supply_source_type_id,subinventory_code
FROM mtl_reservations
WHERE inventory_item_id =
(SELECT inventory_item_id FROM mtl_system_items WHERE segment1='TESTSTD1'
AND organization_id =1)
AND organization_id = 1
/* To get all those order lines which have place a reservation on a particular
item, use this query.*/
SELECT *
FROM oe_order_lines_all
WHERE line_id IN
(SELECT demand_source_line_id
FROM mtl_reservations
WHERE inventory_item_id =
(SELECT inventory_item_id FROM mtl_system_items WHERE segment1='TESTSTD1'
AND organization_id =1)
AND organization_id = 1)
/* Generally any item when it is first created will be assigned a default
category set, which can be defined as part of setup data.
*/
SELECT a.inventory_item_id,a.organization_id, b.category_set_name, c.segment1
FROM mtl_item_categories a, mtl_category_sets b, mtl_categories c
WHERE a.category_set_id = b.category_set_id
AND a.category_id = c.category_id
AND inventory_item_id =
(SELECT inventory_item_id FROM mtl_system_items_b WHERE segment1='LUCKYITEM'
AND organization_id =1)
AND organization_id = 1
SELECT category_set_id,category_set_name,description,structure_id,validate_flag
FROM mtl_category_sets
WHERE description LIKE '%Item%'
SELECT * --category_id,structure_id,segment1, description
FROM mtl_categories
SELECT a.inventory_item_id,a.organization_id, a.category_set_id,
a.category_id--,a.cms_replication_date
,b.segment1,b.description, c.category_set_name, c.description
FROM mtl_item_categories a, mtl_categories b, mtl_category_sets c
WHERE inventory_item_id =
(SELECT inventory_item_id FROM mtl_system_items
WHERE segment1='CISCO TEST ITEM1'
AND organization_id = 1)
AND a.category_id = b.category_id
AND a.category_set_id = c.category_set_id
/* Item attributes and status codes : Item attributes are information
about an item for ex, lead time, revision control, order cost etc. We can have
2 kinds of control levels for these item attributes, which we set at the
time of defining the item. They are master level (which is centralized i.e
attributes defined at master level will have same values at all the org
levels. And in org level the values defined will have different values at
different orgs. ex UOM.
There are two kinds of item attributes,
--- Item Defining attributes
--- Item Status attributes
/* You cannot enable the status attribute, until you set the corresponding
item defining attribute to Yes */
The Item Defining attributes are
Inventory Item
Internal Ordered
Purchased
MRP Planning Method
Costing Enabled
Engineering Item
Customer Ordered
Support Service
Invoiceable Item
All the above item defining attributes are given by the below query.
SELECT inventory_item_flag,
purchasing_item_flag,
internal_order_flag,
mrp_calculate_atp_flag,
costing_enabled_flag,
eng_item_flag,
customer_order_flag,
serviceable_product_flag
--serviceable_component_flag ,service_item_flag
FROM mtl_system_items_b
THe Item status attribute are 8 and they are,
BOM Allowed,
Build in WIP,
Customer Orders Enabled,
Internal Orders Enabled,
Invoice Enabled,
Transactable,
Purchasable,
Stockable.
All these attributes are flags and the following query will give all those attributes. */
SELECT inventory_item_id, organization_id,
bom_enabled_flag, build_in_wip_flag, customer_order_enabled_flag,
internal_order_enabled_flag,
invoice_enabled_flag,mtl_transactions_enabled_flag,
purchasing_enabled_flag,stock_enabled_flag
FROM mtl_system_items_b
WHERE inventory_item_id = 101177
Here is the mapping of the Item defining vs the Item status attributes
Inventory Item (stockable, transactable, BOM Allowed)
Internal Ordered (Internal Orders Enabled)
Purchased (Purchasable)
MRP Planning Method
Costing Enabled
Engineering Item
Customer Ordered (Customer Orders Enabled)
Support Service
Invoiceable Item (Invoice Enabled)
/* Before we go further, let us briefly dwell about the functional area
and the default category sets in Inventory. In Inventory for every functional
area, there is a default category set associated. We can see this from the
setup => Items => Categories => Default Category Sets.
Alternatively we can see that from the database table as well, as given below.
The primary purpose of using the categories and category sets is reporting.
We can generate reports based on them.*/
SELECT ds.functional_area_id,
ml.meaning functional_area_desc, ds.category_set_id,
cst.category_set_name, cst.description category_set_description
FROM mtl_default_category_sets ds,
mfg_lookups ml,
mtl_category_sets_tl cst
WHERE ml.lookup_type = 'MTL_FUNCTIONAL_AREAS'
AND ml.lookup_code = ds.functional_area_id
AND cst.category_set_id = ds.category_set_id
AND cst.LANGUAGE = USERENV ('LANG')
/* Having defined the item defining attributes and the functional areas.
Whenever an item defining attribute is set to yes for an item, then the default
category set of the corresponding functional area is assigned to that item.
Item Attribute Controls. You can choose to have centralized or decentralized
control of item attributes. Defining attribute controls does not determine
the value of an attribute ,only the level at which it is controlled.
As mentioned before, there are 2 kinds of attribute controls, which are
a) item attributes controlling at the master/org level and
b) status attribute value control.
Both these things we can do from the form
setup => Items => Attribute Controls.
*/
SELECT inventory_item_status_code,attribute_name, attribute_value
FROM mtl_status_attribute_values
WHERE inventory_item_status_code ='Active'
/*From the below query we can see that if the status setting is 1 i.e
corresponding to "Sets Value",then it means it is status controlled. and if
the status setting is "Not Used", then that particular status attributes is
not status controlled. The same thing shows up when we go to the form
setup => Items => Status Codes.
*/
SELECT user_attribute_name, user_attribute_name_gui,
status_control_code, -- (1 for status setting "Sets Value", 3 for Status setting "Not Used")
control_level, -- (1 for master,2 for org)
attribute_name,
level_updateable_flag ,attribute_group_id
FROM mtl_item_attributes
WHERE user_attribute_name IN
('BOM Allowed','Build in WIP','Purchasable','Stockable','Invoice Enabled',
'Customer Orders Enabled','Internal Orders Enabled','Transactable')
/* Now let us see the form setup => Items => Status Codes, there we can group
a item status to these set of 8 status attributes and then we can find that. */
SELECT ROWID, inventory_item_status_code,attribute_name, attribute_value
FROM mtl_status_attribute_values
WHERE inventory_item_status_code ='Active'
/*PICKING RULES : Typically the inventory items are stored in different
subinventories,will have different lot numbers and revisions.Which one needs
to be picked will be determined by the picking rules.
We can define picking rules which basically define the order in which
revisions, lots , subinventories and locators are picked for sales orders.
You can get the picking rules from the below query. When you define an
item, you can choose a picking rule that you have defined. When Oracle
Shipping Execution submits requests to Oracle Inventory, it uses the info in
picking rule to generate the picklists for sales orders.
A picking rule can be specified from the order management tab in the Item definition form*/
SELECT picking_rule_id, picking_rule_name, description,
revision_rule ,
lot_rule,
serial_number_rule,
subinventory_rule,locator_rule
FROM mtl_picking_rules
/*As mentioned , there can be various orders that you can define, like revision order, lot order, subinventory
order,locator order. Now in the case of
revision order, you can choose to have the most recent revision or earliest revision effective date.
lot order, pick the lowest lot number or earliest lot effective date
subinventory order , pick by order defined by subinventory, or earliest subinventory receipt date.etc
Subinventory receipt date means, what is the earlies receipt date in that subinventory.*/
/*Item templates. Since we know that there are hundreds of attributes which an item can have,(distributed
across various tabs in form), it can be tedious to enter all these attributes for each item. Hence we can
define a template (for frequently defined items) and then while defining an item, we can choose this template
from Tools => copy from , and then all these attribute values will be defaulted immediately.*/
SELECT rule_id, rule_name,description
FROM mtl_atp_rules
/* The stock locators are basically areas within the subinventory where the
inventory items are stored. Hence each stock locator will correspond to a
subinventory.You can set up an stock locator and assign it to the subinventory
from setup => Items => Stock Locators.*/
SELECT inventory_location_id, organization_id, inventory_location_type,subinventory_code,segment1,status_id,
LENGTH,width,height -- and other dimensional attributes.
FROM mtl_item_locations
WHERE subinventory_code LIKE 'MY%'
/* To know whether a particular inventory item is lot controlled or serial controlled we can run the
below query. Can a item be both lot and serial controlled ????? */
SELECT lot_control_code,-- 1 for no control and 2 for full control.
auto_lot_alpha_prefix,
default_lot_status_id,
fixed_lot_multiplier,
start_auto_lot_number,
std_lot_size
--
serial_number_control_code,
serial_status_enabled,
start_auto_serial_number
FROM mtl_system_items_b
WHERE segment1 ='LUCKYITEM'
/*
Available to Promise (ATP)
ATP computation options :
ATP computations use the consumption and accumulate available features.
Consumption resolves negative ATP after it is already determined that there is not enough
available inventory.
Accumulation uses the excessive inventory from a period to determine where the new demand can be
placed.
Accumulate Available :
This option determines how the
To implement ATP, you have to define ATP rules. ATP rules let you tailor the ATP calculation to suit your business needs.
Each ATP rule is a combination of
ATP computation options
Time fence options
Supply and demand sources
*/
SELECT supply_type_code, supply_source_id,po_header_id, po_line_id, po_distribution_id,item_id,quantity,
destination_type_code,to_organization_id
FROM mtl_supply
--where item_id = 207984204
(SELECT DISTINCT item_id FROM mtl_supply)
SELECT inventory_item_id FROM mtl_system_items_b
WHERE segment1='LUCKYITEM'
SELECT COUNT(*) FROM mtl_demand
/* Just like GL,AR ,Inventory has its own periods as well & we can open period from
setup => costs => cost periods .And the data goes into the org_acct_periods.
Oracle Inventory --> Accounting Close Cycle --> Inventory Accounting Periods --> Change status
In inventory only one period at any time, while in GL or PO any periods can be open.
This is the most trickiest part. Actually in inventory if you need to open
any period, then the previous period needs to be already opened. That is
if the previous period is not open yet, just open and close it.
Also ensure that the purchasing periods are open, however in this case
more than one periods can be open simultaneously.
Setup => Financials => Accounting => Control Purchasing Periods.
If you do not have any item on hand, then you can do a subinventory transfer
of that item and then have some quantity available in the subinventory.
*/
/*
In the general planning tab for an item in inventory, you enter the type of
planner that you use, i.e Min-Max planning method, Reorder Point planning
method or no plan at all.
In the case of Min-Max planning method, you enter the Min and Max amounts
for that item. If a min is entered, you want atleast that amount of that
item on-hand always and if that amount is reached, Oracle inventory will
suggest for placing a new order.
If a max is entered, then you don't want more than the max amount of that item.
Reorder Point Planning : An inventory planning method that is used to determine
when and how much to order based on customer service level, safety stock,
carrying cost, order setup cost, Lead time and average demand.
Minimum Order Quantity : this is the amount of the item that the system
places an order on, whenever it needs to reorder. Ex for discrete items,
when the net requirements fall short of the minimum order quantity, the planning algorithms suggest the minimum order quantity.
Maximum Order Quantity :
Or optionally you can have an item to be MRP/MPS planned.
If an item is vendor managed, then you should enter the planner for that item.*/
-- hr_organization_units is a view based on hr_all_organization_units and
--hr_all_organization_units_tl.
SELECT *
FROM hr_organization_units
WHERE organization_id = 1
SELECT * FROM hr_all_organization_units_tl
SELECT * FROM hr_all_organization_units
WHERE organization_id =1
SELECT * FROM mtl_parameters_view
--Move Order Issue and Mover Order Transfer :
/*Miscellaneous Receipt :
Transactions => Miscellaneous Transaction (type = Miscellaneous Receipt)
Usually if we quickly want some amount of quantity for a particular item,
then we can either do the PO,and receive against that PO. Or we can do a
miscellaneous receipt for that particular item. Obviously when we do a miscellaneous
receipt, we receive that particular item into a particular inventory
organization and into a particular subinventory.
*/
-- Once we log into the Oracle Apps, the Operating unit is chosen by the
profile value 'MO:Operating Unit'.
SELECT * FROM mtl_customer_item_xrefs --_v
/* What are customer items?. Is it same as inventory items with customer orders enabled - NO */
SELECT customer_item_id, customer_id, address_id
,item_definition_level
FROM mtl_customer_items
-- Item Categories Stuff :
/**************************
Usually we will have a lot of structures defined for this particular KFF "Item Categories".
Here the data goes into a key columns of the
underlying table (not descriptive columns like attribute etc). The category id
is the primary key which is based on the unique values of the segment values.
*/
SELECT category_id, structure_id ,attribute_category, attribute2,
segment1, segment2, segment3
FROM mtl_categories_b
/* When we define the category set,we use this particular KFF structure. That
is we can define any number of category sets corresponding to different structures.
Let us go thru the steps required to define a Item category KFF ,structure,
codes and the associated stuff.
1. First step, we have a KFF "Item Categories" and we can define a structure
corresonding to this KFF,using the menu,,
setup => KFF=> Segments
2. The next step is to create the Item Categories or the combinations corresponding
to the Item Category Segment that is being created above. This process is creating
Category Codes. This is done using the menu,
Setup => Items => Categories => Category Codes
And then choose "New". Now we have to start creating the Category Codes,by
choosing the structure in the Structure Name field. This is the same
structure that we have created in step 1 . Now once we come to Category
field, we enter the values corresponding to all the segments for this particular
structure. Basically here we are enterting the combination of values. If each
segment has a value set attached to it in the segment definition, then we
have to choose from the valueset, otherwise we can enter any values we want to.
So like this, we define as many Item categories i.e combination of values as
we want. So each such combination is a item category. A set of such
combinations is called a category set.
3. The next step is we come to the Category Sets form,
Setup => Items => Categories => Category Sets
In this step we create a Category Set. that is, we form a set of combinations
that we have created in the above step.
Hence in this from,we enter a Category Set name and description and in the
Flex structure field, we enter the same structure that is created in the
step 1. And in the below block, we enter all/some of the categories that are
created in the above step 2. We also specify what is the default category
for this item.
Hence a very important point to note here is that,out of all the structures we
choose the structure by category set. There is nothing like profile value which
choose the particular structure or the particular category set. We can use
multiple category sets at the same time for multiple inventory items and
hence there is no option to set a specific category set.
This concludes the Item Category Setup. Having created different categories
and category sets, we can now assign Items to Item Categories.
Essentially we assign items to category sets just for reporting and grouping purposes.
Now we come to the item master,choose a particular item and from the menue
Tools => Categories
We can assign this item to a particular category set. What we need to understand is that
when we assign item to a category set, we choose a specific value out of all the values
in that particular category set.
This tells us that this item belongs to that particular category. */
SELECT * FROM mtl_categories
where creation_date >= trunc(sysdate)
SELECT * FROM mtl_category_sets_b
What are the different types of Miscellaneous transactions.
interorg transfer.
what are inventory picking rules (Verisign does not use the inventory picking rules)
Usually since the valid GL combination codes are already created in GL, using the Account generator , it
is handy to go to GL and keep such combination,which can be used for entering the acct info in transactions.
011.2120.0000.140060.0000.000.000000 - Asset
011.9000.0000.250010.0000.020.000000 - Liability
011.9000.0000.360010.0000.000.000000 - Owners Equity
I think the account receipt/issue is basically a Miscellaneous receipt/issue, with the exception that
we specify a gl account at the time of receipt/issue.
It is important to note that for everything that we do in the Purchasing or OM, has an impact in Inventory in the
form of transactions. That is if we do a sales order pick release, then immediately a inventory transaction
happens with the corresonding trasacation type (Sales Order Pick). And also the onhand quantities etc will get
reflected accordingly.
Now we want to see if we do an internal req, does it do a corresponding internal req trx type in Inventory and for
that, create an internal req, and see whether it shows in the material transactions
as po req relation transaction type. ???????????????
req # 119035042
Make sure that the item that you are ordering is Internal Order enabled.
For any internal orders, the price is automatically defaulted to 0
Also make sure the bill to location is specified for the internal customer
WHY the delivery did not get created and i had to create a auto create delivery. ????????????
*/
--We can try to see what kind of transactions did what amounts from,
SELECT b.transaction_type_name,COUNT(*)
FROM mtl_material_transactions a , mtl_transaction_types b
WHERE a.transaction_type_id = b.transaction_type_id --and transaction_type_id = 64
GROUP BY b.transaction_type_name
SELECT * FROM mtl_material_transactions WHERE transaction_type_id = 64
/* For each type of inventory transaction we will have the accounting information.
however for some of items like expense item, we may not have the accounting records
in the mtl_transaction_accounts.
Why is that we are not seeing the mtl_transaction accounts records for all the
transactions even though it is an inventory item, not expense item. ????????
Basically, the inventory classifies an item as an asset type item, based on the
subinventory. If we place a sales order on an asset item which is stocked in
an asset subinventory.
Usually pick release process can use a pick release rule which tells it to go
to which subinventory andget it from. However even with out the rule, we can
choose at the time of pick release ,which subinventoryshould be chosen.
Interestingly, when we place an order, we can tell which inventory org in the
form of the warehouse. we can also see the subinventory field(but not able to
select value in it). If the pick release process picks it from an asset subinventory,
then it goes ahead and creates the transaction accounts in the table,
*/
SELECT * FROM mtl_transaction_accounts.
/*And if the item is picked from the expense subinventory , then it does not find
an entry in the transaction accounts.
In the case where an item is received both in expense and asset subinventory and
there is no picking rule, when I try to pick release such kind of item, I
encountered an error, this is probably because the system is confused to pick that
item from which subinventory. Oracle is not designed to handle this kind of cases.
Even though you define an asset item, you have to receive that item (using PO, Misc trx) into an asset
subinventory, otherwise the transaction accounts will not be generated. We can try to do a subinventory
transfer of an asset item from asset subinventory to an expense subinventory. What this effectively
means that we are moving a specific amount of quantity of that asset item to the expense subinventory
as it is of no use/damaged. So this effectively means that we do not have any items in our asset subinventory.
what happens when we post it to GL. ???????
*/
1). What are shipping Networks ?
Shipping networks determine between which two organizations you can do an inventory
transfer. That is ,say if you want to do an inventory transfer between two inventory
organizations M1 and M2, then you must define a shipping network between these two
inventory organizations and specify whether you want this transfer to be
-- Direct Or
-- Intransit
2). Explain the Inter-org transfer?
Inter-org transfer is the transfer of items between two different inventory organizations.
Remember this is not a transfer between two subinventories of the same inventory
organization, but it is between two inventory organizations. You can create an
inter-org transfer using the menu
Transactions => Inter-org Transfer
The from Org is the current inventory Organization.
The LOV for the To org is determined by the shipping networks that you define between
the from Org to different organization. The shipping networks are defined here
Setup => Organization => Shipping Networks.
You will be able to do an inter-org transfer to a particular destination organization
only if the internal order enabled flag is not checked in the shipping networks.
3). what is the difference between transactable and oe transactable??
transactable means u can perform transactions on that item. i.e you can enter orders and book them.
oe transactable means that trasactions can be interfaced to oracle inventory, that means, some of the transactions like pick release (which involve inventory transactions) cannot be performed, if you don't set this flag. mostly if the shippable flag is set, oe transactable is set, but if shippable is not set, you could still set this flag, for forecasting purposes.
4). How do you create a Kit in Inventory ?
Create an item in Inventory,set it as inventory item, standard BOM and set pick components to Yes. This constitutes a kit, say xyz.
So a kit is a standard BOM with only mandatory components
So basically all you do in a kit is to select items in the kit like (one cd, one hardware security token, one user manual). So the kit does not have a work in process (wip) involved,only picking. Another important point is that a kit by itself will not onhand in inventory. Which means you will have on hand for cd, token and manual but no onhand for the kit xyz.
OR
More easily ,just create an item and set the item type template as KIT in the main tab,and in the template all the appropriate flags will have been set.
One thing, interested I noticed is that when you create a kit item, the shippable flag is not set,although the kit itself is shipped right? May be what that means is that there are no delivery lines created for the kit itself,as opposed to the component items for which the delivery lines are created.
We're only shipping the components and the Kit item is a logical unit. however in the case of ATO, we make ATO shippable since we ship the entire assembly and not individual components there.
PTO configuration has the extra step of clicking on the configurator button to choose the items.
5). What is the difference between Asset type and Expense Types ??
Asset Type and Expense Type are opposite: (Expense account is also called as Charge Account)
Earlier we have mentioned that, move orders are the orders which are used for moving the items between the
subinventories. However if we need to move the items across inventory organizations ,then we can use the
Internal Requisition process. In the Internal Requisition process, we have a clear way of mentioning the destination
and the source inventory organizations. At the lowest level, each item is stored at the subinventory level.Each
subinventory is either of asset type or expense type.
Hence there is no concept of inter-org transfer if we have only one inventory organization.
An item is created as an ASSET item by setting the flag in the tab
Costing => Inventory Asset Value (and also costing enabling)
and you also mention the COGS account. An Asset item's cost is realized at the time of selling that item. All
stockable items are asset items.(Stockable item means no expense, it is an asset)
An item is created as an EXPENSE by NOT setting the flag in the tab
Costing => Inventory Asset Value
However in this case, we have to mention what is the Expense account. An expense item cost is realized
at the time of purchasing that item. Expense item means small items like stationery, pencils etc.
6). What is the difference between subinventory transfer, move order
(transaction mover order) ??
Both the Move order as well as the subinventory transfer do the same result,
i.e they move the item from one subinventory to another. However with the
Move order, we have more functionality available.
Usually the system creates the Move order. Generally if we want to do a
subinventory transfer we would go ahead and do the transfer,however some of
the other modules like Manufacturing can potentially do the transfers. In that
case, they would create a Move order. However someone should open that Move order
inspect it and approve that Move order,so that either subinventory transfer or
account issue will happen. So the move order is a two step process,where in we
first create,approve,allocate the move order and then transact it.
Look at OM stuff for more information.
7). How to setup a Master Organization ??
First we create an organization using the hr responsibility. once an
organization is created,then we can use the menu
setup => organizations => parameters
to set up that organization as a master organization.
In here, we can also set up the child organizations
*/
So to setup each child organization ,go to the change organization menu option,choose
your inventory organization and after that,come to organization parameters and choose
your master organization.
8). What is the difference between Item Cross Reference and Customer Item Cross Reference?
Customer Item Cross Reference is a particular instance of Cross references.
Item Cross Reference is a generic term which can be used to define reference
with Customer's Items and Supplier's Items
For Item cross reference is used to track the old items or the supplier
items. That is ,if the same item is referred by a different name by the
supplier then, the item cross reference will map these two names.
For Customer item cross reference,is probably used ,say for the sales guys to place the order on items, by
which they remember. Thatisif a particular item 'Myitem" is referred to as 'abcd1' using the
customer item cross reference, then we can go to the sales order from and in the line item
we can refer to this 'abcd1' to place an order on that item.
But usually the customer item cross reference, is when you are loading the data from EDI 40 etc. That is
a customer sends an xml kind of file for placing a sales order and that file consists of all the customer
item references and not oracle item references.
*/
9). What is the difference between Operating Unit and Inventory Organization ?
In some of the important modules like OM, Purchasing etc tables we find that
there is and org_id. this is actually an operating unit id (and not to be
confused with the inventory org id). And when we log into the applications,
the operating unit is already set from the profile parameter 'MO:Operating Unit'.
However in the inventory module, the org id that we are always referring to
is the inventory org id (and not the operating unit id).
When we enter the Inventory module, we are always prompted to choose a
particular inventory org id.
Usually when we create an item, we always assign it to an org id, i.e what
this means is that we can transact this item with in that particular
inventory org id. That is particularly we can purchase, sell with in that
inventory org id.
When we create an org it is always associated with a location and hence it
goes into the hr_organizations and hr_locations. It is important to know
that both the employee locations and the inventory locations go into
the same table hr_locations.*/
10). What are Organization attributes /
Organization Attributes : Usually we create an item in the Master org, set
all its attributes and then assign that item to a different inventory
organization. However it is important to note that some attributes may not
be set into the new organization,so from the organization manager.
We can click on the org attributes and set the attributes of the item accordingly.
11). What are item attributes?
There are two kinds of item attributes,
--- Item Defining attributes
--- Item Status attributes
The following is the mapping between item defining and status attributes
Inventory Item (stockable, transactable, BOM Allowed)
Internal Ordered (Internal Orders Enabled)
Purchased (Purchasable)
MRP Planning Method
Costing Enabled
Engineering Item
Customer Ordered (Customer Orders Enabled)
Support Service
Invoiceable Item (Invoice Enabled)
Build in WIP and Recipe enabled are status attributes for which there is no
corresponding item defnining attirubtre.
12). What do you mean by when an item is in status control ?
I’m sharing the information. Creating this blog is not just a hobby it’s a partnership to grow together.
339 comments:
1 – 200 of 339 Newer› Newest»Awesome Post Prashant....keep it coming....
Hey there, You have done an incredible job. I will
certainly digg it and personally suggest to my friends. I am confident they will be
benefited from this web site.
Check out my site how to download movies
You can apply both equally Sam even if you should certainly concentrate on your evaluation site by itself.
My webpage - Genital Warts Cures
Hi there valuable content. I did somewhat difficulity taking a look at this
article onSafari although, not sure precisely
why?
Look at my web site exceltriathlon.com
[url=http://ivlkrwnnz.com]QuPLnsilFahxLQNZu[/url] - iXzgeq , http://hhmgziigpu.com
We absolutely love your blog and find the majority of your
post's to be exactly I'm looking for. can you offer guest writers to write content to suit your needs?
I wouldn't mind creating a post or elaborating on a number of the subjects you write about here. Again, awesome web log!
Have a look at my site - forja
Hello, i think that i saw you visited my weblog thus i came to “return the favor”.
I am attempting to find things to enhance my site!
I suppose its ok to use a few of your ideas!!
Here is my homepage :: bacalao
Fabulous, what a blog іt is! Thіs web
site giveѕ valuable infoгmation tο us,
keep іt up.http://dϳ.beatρort.
cоm/events/39614
Here is my site : Silver Linings Playbook 2012 Movie
It's wonderful that you are getting ideas from this paragraph as well as from our discussion made here.Rise of the Guardians HD Free Streaming
My webpage > Rise of the Guardians HD Free Streaming
Very quickly thiѕ ωeb pagе ωill
be famоuѕ among all blog usеrs, due to
іt's pleasant contenthttp://dj.beatport.com/events/40108
My weblog - Watch Doctor Who Season 7 Episode 0 The Snowmen Online Free Stream
Excellent blog right hеre! Αlso yοur web sitе loаds
up verу fast! What ωeb host аre yοu the
use оf? Can I gеt your аffiliate hypeгlink
in your host? ӏ want my sitе loaded uρ as quіckly аs yоuгs lolhttp:
//dj.beatport.com/events/40113
Feel free to surf my web site - Watch Rizzoli & Isles Season 3 Episode 15 No More Drama in My Life Online Free Stream
Quality content is the secret to interest the visitors to
go to see the web page, that's what this web page is providing.
Here is my web blog : to get my ex girl back
This is the perfect website for everyone who really wants
to understand this topic. You realize so much its almost
tough to argue with you (not that I actually would want to…HaHa).
You definitely put a brand new spin on a topic which has
been discussed for decades. Great stuff, just excellent!
Also visit my web blog ... ignoring your ex to get him back
I love your blog.. very nice colors & theme. Did you
make this website yourself or did you hire someone to do
it for you? Plz answer back as I'm looking to design my own blog and would like to find out where u got this from. thanks a lot
Feel free to surf my web page how to get Your ex back reviews
you are actually a excellent webmaster. The site loading speed is incredible.
It seems that you are doing any unique trick. Also, The
contents are masterpiece. you have performed a excellent
activity in this subject!
My site ; http://www.sait-rabota.ru
If you are going for best contents like I do, only go to see this web site all
the time for the reason that it provides quality contents, thanks
Feel free to visit my website : vacation reply
Thank you for some other fantastic post. Where else could anyone get that type of info
in such an ideal approach of writing? I've a presentation subsequent week, and I'm at the search for such information.
Here is my blog - hotmail sign in mobile phone
I was recommended this website by way of my cousin.
I'm no longer certain whether or not this submit is written by him as no one else know such distinct about my problem. You're wonderful!
Thank you!
My blog ; right hotmail support
Why is this being allοweԁ use
on ρeоple with Cerebrаl pаlѕy in Canada?
Also visit my weblog botox sydney
When someone writes an post he/she keeps the plan of a user in his/her mind that how a user can be aware of it.
Therefore that's why this article is perfect. Thanks!
My site: urantit.com
Can I inquire if you are from Qld? You actually
seem like a strong Australian :2)
Have a look at my blog :: Instant Car Insurance Quote
Generally I don't learn post on blogs, but I would like to say that this write-up very pressured me to try and do so! Your writing taste has been amazed me. Thanks, very great article.
My site :: action plan template free download
We stumbled over here different website and thought I might
as well check things out. I like what I see so now i am following
you. Look forward to going over your web page again.
Also visit my web-site ... dryangeducation.com
Site's character and a great color match .. Göğüs estetiğiI will recommend your site to the other platforms.
Hi! My name iѕ Vivian and Whеn I јust wanted to
say уοuг blоg is great! Ιt truly iѕ hilarious becauѕe I use
tο have a weblοg that nеaгlу had an idеntiсal web аԁdress:
http://wωw.blоggеr.com/comment.g?blogID=7564013660709580418&рostID=7831803572742878391 mine was onlу а few characterѕ dіfferеnt.
Nonethelesѕ, I'm a big fan of your weblog and if you at any time want a guest post please make sure to email me personally at: lyn-sheridan@gmail.com. I absolutely adore writing!
Have a look at my web-site ; yeast infection no more pdf
игровые автоматы морской бой лицензия [url=http://nertowinatextest.narod.ru/infa25.html]игровые автоматы на деньги[/url] игровые автоматы играть бесплатно и без регистрации
[url=http://aluejxfttk.com]MCXZEjmgtUKMK[/url] - uOYBG - http://iluubcb.com
I am regular reader, how are you everybody? This article posted
at this website is actually fastidious.
Stop by my page :: http://article-club.info
Incredible quest there. What occurred after?
Thanks!
Here is my web-site; http://www.remembermetillwemeetagain.com/
What's up it's me, I am also visiting this web site on a regular basis, this website is truly nice
and the viewers are actually sharing nice thoughts.
Feel free to visit my weblog: http://intra.vasemmisto.org
Excellent goods from you, man. I have understand your stuff previous to and you're just too excellent. I really like what you have acquired here, really like what you're stating and the way in which you say it.
You make it entertaining and you still take care of to keep it sensible.
I can not wait to read far more from you.
This is actually a terrific website.
Feel free to surf to my homepage ... http://rubycomtest.com/scape/elgg/pg/profile/AnnieBart
my site :: www.kadirmihran.net
Piece of writing writing is also a excitement, if you be familiar with after that you
can write if not it is difficult to write.
Feel free to surf to my web blog :: http://netfriendz.com/
Hiya very cool website!! Man .. Excellent .. Superb .
. I'll bookmark your website and take the feeds also? I'm happy
to search out a lot of useful information here in the submit, we want work out more techniques on this regard,
thanks for sharing. . . . . .
Hello to every body, it's my first pay a quick visit of this webpage; this webpage contains remarkable and in fact fine information in favor of visitors.
Feel free to visit my website: picsforce.com
I think the admin of this site is genuinely working hard in favor of his
web page, because here every data is quality based information.
Look at my web-site; website
Also see my page :: website
You have made some really good points there. I checked on the web for
more info about the issue and found most individuals will go along with your views on this site.
Have a look at my site: www.jaktodays.com
Hi there! Do you know if they make any plugins to help with SEO?
I'm trying to get my blog to rank for some targeted keywords but I'm
not seeing very good results. If you know of any please share.
Appreciate it!
Here is my website: scopevideo.com
I every time spent my half an hour to read this website's posts every day along with a mug of coffee.
Here is my web-site; http://peepmeet.com/pg/profile/EzequielK
Woah! I'm really loving the template/theme of this website. It's simple, yet effective.
A lot of times it's hard to get that "perfect balance" between usability and visual appeal. I must say you've done a awesome job with this.
Also, the blog loads extremely quick for me on Opera.
Outstanding Blog!
Thanks for sharing your thoughts about dress.
Regards
Here is my web site :: sociopoints.info
My web site - org.fj
Useful information. Lucky me I discovered your website accidentally, and I
am stunned why this twist of fate did not happened in advance!
I bookmarked it.
Here is my web blog www.turningheads.co.za
What's up to all, how is everything, I think every one is getting more from this site, and your views are nice designed for new people.
my webpage: quake.ethz.ch
That is a good tip particularly to those new to the blogosphere.
Brief but very precise info… Appreciate your sharing this one.
A must read article!
my web site; website
Magnificent beat ! I would like to apprentice while you amend your website, how can i subscribe for a blog web site?
The account helped me a acceptable deal. I had been tiny bit acquainted of this your broadcast offered
bright clear idea
Review my blog post :: http://pozhive.com
my webpage > http://www.j3305.com
I used to be recommended this blog by way of my cousin.
I'm now not certain whether or not this submit is written via him as no one else realize such precise about my problem. You are wonderful! Thanks!
Here is my web page ... aboutunlockingiphones.com
Hello there! This is kind of off topic but I need some advice from an established blog.
Is it very difficult to set up your own blog?
I'm not very techincal but I can figure things out pretty fast. I'm thinking about setting up my
own but I'm not sure where to start. Do you have any ideas or suggestions? Thanks
Here is my site - www.lesandlynnessocialsite.com
Woah! I'm really digging the template/theme of this website. It's simple, yet effective.
A lot of times it's tough to get that "perfect balance" between superb usability and appearance. I must say you have done a awesome job with this. Also, the blog loads extremely quick for me on Opera. Excellent Blog!
A fascinating discussion is worth comment. I do believe that you need to
write more on this subject, it may not be a taboo
matter but typically folks don't speak about these subjects. To the next! Best wishes!!
Also visit my site: http://www.chatterslounge.com/
What's up mates, how is everything, and what you would like to say about this post, in my view its actually remarkable in favor of me.
Visit my webpage ... www.dawnmona.com
I do not know if it's just me or if perhaps everyone else encountering problems with your website. It appears like some of the written text within your content are running off the screen. Can someone else please provide feedback and let me know if this is happening to them as well? This might be a issue with my internet browser because I've had this happen before.
Many thanks
Wow that was odd. I just wrote an incredibly long comment
but after I clicked submit my comment didn't appear. Grrrr... well I'm
not writing all that over again. Anyways, just wanted to say fantastic blog!
My blog - pakhazara.com
My web site > http://phpfox3.demo.easymods.co.uk/index.php?do=/profile-35646/info/
Thanks in support of sharing such a fastidious idea, piece of writing is fastidious, thats
why i have read it fully
Here is my blog ... http://breezoom.com/index.php?do=/profile-19191/info/
Just desire to say your article is as surprising. The clarity in your post is simply great and
i can assume you are an expert on this subject. Fine with your
permission let me to grab your RSS feed to keep updated
with forthcoming post. Thanks a million and
please keep up the enjoyable work.
Feel free to visit my web page; article-promotion.info
Hey I know this is off topic but I was wondering
if you knew of any widgets I could add to my blog that automatically tweet my newest twitter
updates. I've been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.
Feel free to visit my homepage: www.moneymakingparents.com
Wonderful article! That is the kind of information that are meant to be
shared across the internet. Disgrace on Google for now not positioning this publish upper!
Come on over and discuss with my web site . Thanks =)
Check out my web blog; https://vle.um.edu.mt/mvu/user/view.php?id=32277&course=1
Oh my goodness! Incredible article dude! Thanks, However I am
experiencing difficulties with your RSS. I don't understand the reason why I am unable to join it. Is there anybody getting similar RSS problems? Anyone who knows the answer can you kindly respond? Thanks!!
Here is my webpage ... motion.mediadeling.com
Its like you read my mind! You appear to know a lot about this, like you wrote the
book in it or something. I think that you can do with a few pics to drive
the message home a little bit, but other than that, this is wonderful blog.
An excellent read. I'll definitely be back.
Feel free to visit my web-site; www.kenichiroasami.com
my website: equal.moodle.pl
Nice post. I learn something totally new and challenging on sites I stumbleupon everyday.
It's always helpful to read content from other writers and use a little something from their websites.
Here is my web site - www.vpchatbook.com
Also see my site > therideremuda.com
This design is wicked! You obviously know how to keep a reader
amused. Between your wit and your videos,
I was almost moved to start my own blog (well, almost.
..HaHa!) Wonderful job. I really loved what you had to say, and more than that,
how you presented it. Too cool!
Here is my homepage website
When I originally left a comment I appear to have clicked on
the -Notify me when new comments are added- checkbox and now every time a
comment is added I get 4 emails with the exact same comment.
Perhaps there is an easy method you are able to remove
me from that service? Kudos!
Also visit my blog post: website
I have study much concerning without charge blogging web pages, but I have no
clear idea about that, can any one advise me which one is finest in favor of free blogging and site-building?
My web blog http://www.tuctown.com/
Having read this I thought it was very informative. I appreciate
you taking the time and effort to put this article together.
I once again find myself spending way to much time both
reading and commenting. But so what, it was still worth it!
Here is my web-site; trustablehosts.com
What’s up friend, what a quality is! For this YouTube video, I am in fact pleassant, because
I have never seen pleasant quality YouTube video before,
Also visit my web-site ... http://urswag.biz/
It’s an remarkable article in support of all the web visitors; they will
take advantage from it I am sure.
My page http://pozhive.com
Remarkable YouTube movies posted at this site, I am going to subscribe for on a
regular basis updates, as I don’t want to miss this
series.
Check out my web-site - website
I don’t waste my free time in watching movies except I go for to read
posts on net and get updated from newest technologies.
Feel free to surf to my blog www.greenagora.com
What’s up friend, what a quality is! For this YouTube video, I am in fact pleassant, because I have never seen pleasant quality YouTube video before,
Here is my blog post; website
Hello, how’s it going? Just shared this post with a colleague,
we had a good laugh.
My website: website
What’s up I am from Australia, this time I am viewing this cooking related video at this
site, I am genuinely happy and learning more from it. Thanks for sharing.
My blog; website
These all YouTube gaming video tutorials are actually in pleasant quality, I
watched out all these along through my colleagues.
Also visit my page - wk2006cam.nl
My website :: website
Such are in fact cool YouTube movies, its my luck to go to
see this web page and finding these awesome YouTube movies.
Here is my web-site ... http://fortalonline.com.br/index.php?do=/blog/31468/diverse-gains-of-coupon-codes-for-merchants/
A number of viewers are keen to watch comic video clips, but I like
to watch terrible videos on YouTube.
Stop by my web page: http://fb.fullorissa.com
Wow, this article is pleasant, my younger sister is analyzing these kinds of things,
so I am going to tell her.
My web page: website
Also see my page > 4solution.net
Hi, I just wanted to tell you, you’re dead wrong. Your article doesn’t
make any sense.
Also visit my homepage - orlandochristiansingles.org
My web page > http://formacion.dimensioneducativa.org.co/
Thanx for the effort, keep up the good work Great work, I am going to start a small Blog Engine course work using your site I hope you enjoy blogging with the popular BlogEngine.
net.Thethoughts you express are really awesome. Hope you
will right some more posts.
My web blog ... website
Hi, I can’t understand how to add your site in my rss reader.
Can you Help me, please
My web blog website
Great articles & Nice a site….
My blog twitup.altervista.org
What a video it is! Actually amazing and fastidious quality, please
upload more movies having such good quality. Thanks.
Visit my page cancerfightersz.com
Hello webmaster I like your post ….
My web site :: website
Hello dear, are you enjoying with this humorous YouTube video?
Hmmm, that’s good, I am also watching this YouTube joke video at the moment.
Visit my webpage; http://www.habboqueen.com/grupo/blogs/user/Ariel11W
Hi there to every body, it’s my first go to see of this web site; this weblog
consists of awesome and in fact good stuff for visitors.
Here is my page tuctown.com
Actually picture is the presentation of some one’s feelings; it provides the
lesson to the viewers.
Here is my site ... http://veryhelpful.info/SJPoF/pg/profile/Alissa846
Saved as a favorite, I really like your blog!
Look into my website lookingforarrangement.com
Also see my webpage :: mohawkschools.org
Interesting article. Were did you got all the information from.
..
Feel free to visit my blog: www.datecity.com
If you are free to watch funny videos online then I suggest you to go to see this website, it contains in fact thus humorous not only
movies but also additional information.
my website ... http://www.facebook.giaynu.net/profile/rosettalar
Hi there! This post couldn’t be written any better!
Reading through this post reminds me of my previous room mate!
He always kept talking about this. I will forward this article to him.
Pretty sure he will have a good read. Thank you for sharing!
my web blog: competitors.wvcombatsports.com
Also see my page: ork2.com
Sketches are in fact pleasant source of teaching instead
of content, its my familiarity, what would you say?
Feel free to visit my website - website
Also see my website > teste.iclipgospel.net
This post on the topic of how to embed a YouTube video code is really
valuable designed for fresh internet access visitors. Pleasant
work, keep it up.
Also visit my webpage; website
One more technique in favor of promoting your web site is posting comments
on different sites with your weblog link.
Feel free to visit my homepage; http://rupeerains.info/
My webpage: http://www.tlcinstituteonline.org/
Your blog is so informative … keep up the good work!
!!!
my web site: http://everydayinjesus.com/groups/how-you-can-increase-the-beauty-of-your-home/
I usually don’t post in Blogs but your blog forced
me to, amazing work.. beautiful …
my weblog http://maggiesglutenfree.com/node/317263
My webpage :: http://weseetruth.com/link/6927
What’s up, for Search engine optimization genuine
contents are actually needed, if you only make a copy and paste then you can not ranked in search engines.
Also visit my web-site: http://www.coach9.com/
gr8 resrch bro…
My webpage ... website
Hi there I like your post
Feel free to visit my weblog - http://salsabravapro.com/
I think a visualized display can be better then just a straightforward text,
if stuff are defined in graphics one can without
difficulty be familiar with these.
Feel free to visit my webpage website
My site > rdsocial.com
Wow! It’s a nice jQuery script; I was also seeking
for that, thus i got it right now from at this time.
Keep it up admin of this site.
Have a look at my weblog :: alex-cyr.com
My web site > mediabeamspk.com
Why visitors still make use of to read news papers when in this
technological world everything is accessible on net?
Feel free to surf to my web page http://www.funkenya.com/
This webpage is containing a pleasant stuff of humorous YouTube video lessons, I loved it
a lot.
Here is my site; http://lonelyguy.org/read_blog/17523/the-various-kinds-of-fire-pit-tables
Also see my site :: website
I am truly eager of watching comic videos at youtube, and this videos is truly
so comic, hehehhe.
My weblog ... oxygen-4u.com
Also see my web page - social.wpu4u.com
Hahahaha, what a comic this YouTube record is! We are still laughing, thanks to admin who had posted at this web
page.
Check out my web blog :: northsydneydive.com.au
I got so bored in the present day afternoon, but as soon
as I watched this YouTube comical clip at this blog I turn into
fresh and glad too.
Also visit my website ... www.redeyegator.com
My website - http://www.autismoutofthebox.com
On every weekend, we all mates jointly used to watch movie,
because enjoyment is also essential in life.
Here is my weblog :: http://sex.facehoster.com/blog/view/349575/how-to-make-use-of-coupons-smartly
Article writing is also a excitement, if you know then you can write otherwise
it is difficult to write.
Also visit my website slepcianska15ka.sl.funpic.de
Hi! I know thіs іs somewhat off-topic but I needeԁ to ask.
Doeѕ running a wеll-established website such as уouгs require a maѕsive amοunt wоrk?
I'm brand new to blogging however I do write in my journal on a daily basis. I'ԁ like
tο ѕtaгt a blog ѕo I will be able to shаre
my own experience and vіeωs onlіne.
Рlease let mе knoω if yοu have anу recommendations or tips for brand nеw aspirіng bloggeгs.
Thankyou! please click the following webpage
my page: please click the following webpage
Nice answers in return of this query with real arguments and explaining all about that.
Feel free to surf to my web blog :: www.dawnmona.com
Also see my web page :: website
Truly it’s called Search engine marketing that when i search for this
paragraph I found this site at the top of all blogs in search
engine.
Here is my weblog http://member.marketingbodz.com/blogs/entry/How-efficient-are-coupons
my page: sportfc.net
At present I was so tired, and now this time I have got
some relax by watching this funny YouTube video, thanks, keep it up.
Also visit my site website
Also see my web page: chillwithfriends.com
Thanks for some other informative web site. Where else may
just I am getting that type of information written in such an ideal way?
I've a project that I'm just now running on, and I have been at the glance out for such
information.
my web-site; www.talismanscholarship.co.uk
Hello dear, are you enjoying with this humorous YouTube video?
Hmmm, that’s good, I am also watching
this YouTube joke video at the moment.
Visit my page ... website
When I initially commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get three emails with
the same comment. Is there any way you can
remove people from that service? Appreciate it!
my weblog: meratol reviews
On every weekend, we all mates jointly used to watch movie, because
enjoyment is also essential in life.
Feel free to surf to my web site http://plae.com/
Please upload more movies related to cooking if you have,
for the reason that I would like to learn more and more about all
recipes of cooking.
Feel free to visit my web page :: www.comclub7.com
I have read so many posts about the blogger lovers except this post
is in fact a nice paragraph, keep it up.
My web blog: www.libanonchat.org
Also see my webpage: website
Nice post! GA is also my biggest earning. However,
it’s not a much.
Feel free to visit my website http://www.temploonline.org
I visited multiple websites but the audio feature for audio songs existing at this website is genuinely marvelous.
my weblog http://www.gabbitt.com/index.php?do=/blog/71926/know-the-necessity-of-cash
my website > iplaygosports.com
Hi Dear, are you truly visiting this website daily, if so after that you will definitely get good
knowledge.
Look into my web page; freearticlesites.co.uk
I am keen of learning Flash, is there any piece of writing related to
Flash, if okay, then please post it, thanks.
Feel free to surf to my web-site ... americanlegionpost569.com
Hi everybody, I am sure you will be enjoying here
by watching these hilarious videos.
my web-site http://dfwherald.com/read_blog/19941/do-you-know-the-different-functions-of-the-world-wide-web?
Hi there, thanks for all the visitors, I will upload many more video clips in coming days, admin
Here is my homepage: website
My site > http://www.dawnmona.com/
There is obviously a lot to know about this. I think you made
some good points in Features also.
Visit my web blog fortalonline.com.br
My page > website
Such a usefule blog…wow !!!!
My web page: www.programaformacionintegral.cl
Your method of explaining the whole thing in this post is in fact pleasant, every one be capable of effortlessly be aware of it, Thanks
a lot.
my homepage: sekepat.com
Hi there I like your post
My web page; test.medicalmummies.org
Everything is very open and very clear explanation of issues.
was truly information. Your website is very useful. Thanks for sharing.
Visit my blog post ... teleobjetiva.com.br
I don’t usually reply to posts but I will in this case.
WoW
My web page :: http://media.vitalland.hu
my webpage - http://childrights.md
This is a very good tips especially to those new to blogosphere, brief and accurate information… Thanks for
sharing this one. A must read article.
Feel free to surf to my web-site ... www.afrikameet.com
What’s up it’s me Fiona, I am also visiting
this web site regularly, this web page is truly nice and the users are genuinely sharing good thoughts.
Also visit my weblog http://ensynefo.com
Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me.
Anyways, I’m definitely happy I found it and I’ll be
book-marking and checking back frequently!
Feel free to surf to my page; http://iddeenspeaks.com/network/index.php/blogs/23447/95656/functions-of-domain-name-server
My page > www.finedining.chrisedwardsdesigns.co.uk
YouTube is world’s biggest video sharing site, no
one can defeat it. Every one upload movies at YouTube after that obtain embed code and post anywhere.
Here is my page - monrezo360.com
Please, can you PM me and tell me few more thinks about this, I am really fan of your blog.
..gets solved properly asap.
Also visit my webpage website
My web site - kilbil.com
If you apply these kinds of methods for increasing traffic on your own
webpage, I am sure you will notice the change in few days.
Here is my web site http://dogsomg.com/read_blog/188169/run-your-small-business-your-way-with-fatcow-hosting
Its extremely brilliant YouTube video in terms of features, actually good, its quality is genuinely appreciable.
Also visit my blog post www.firecrew77.com
Why visitors still make use of to read news papers when in this
technological world everything is accessible on net?
my web page: http://ontheqtease.com/garagewars/read_blog/58461/ipage-internet-hosting-for-new-websites
Wonderful, what a blog it is! This webpage provides useful data
to us, keep it up.
Feel free to visit my blog; http://www.facelap.com/blogs/22249/17172/tips-on-how-to-come-across-the-v
Greetings! Very helpful advice on this article!
It is the little changes that make the biggest changes.
Thanks a lot for sharing!
Also visit my web blog :: website
Hello, I also would like to share my opinion here, when i don’t know even about a straightforward thing related to Personal
home pages, I always go to explore that from internet.
Feel free to visit my homepage; http://facekuban.ru
good good…this post deserves nothing …hahaha just
joking :P …nice post :P
Feel free to visit my homepage; https://astrophysics.gsfc.nasa.gov/lobsterwiki/MarcelWvo
Remarkable video, actually a pleasant quality, this
YouTube video touched me a lot in terms of features.
Here is my page - http://bluebirdseasonaire.com
YouTube is world’s biggest video sharing site, no one can defeat it.
Every one upload movies at YouTube after that obtain embed code and post anywhere.
Feel free to surf to my homepage - website
Also see my web site - website
Hi, all right brother there are certainly multiple blogging web
pages, but I recommend you to use Google’s free blogging services.
Also visit my webpage :: http://pridefolio.com/
For most up-to-date news you have to pay a visit internet and
on world-wide-web I found this web site as a best website for most
up-to-date updates.
Here is my page; http://ethinklearning.com
Hi, I can’t understand how to add your site in my
rss reader. Can you Help me, please
Here is my blog post :: kaunbanegacrorpati.com
Wow, thanks a bunch m8
Also visit my homepage ... website
my webpage: http://article-crash.info/
Between the traditional methods of traditional
hair removal, waxing can be considered one of the methods which prolongs hair
regrowth more than usual strategies. The offside to the approach is the fact that,
it is just a complicated and painful procedure that not every person likes.
Here is my web site :: http://easyhairremovalguide.com/
If you need more effective approaches to lose stomach fat
then one could search on the internet.
My website :: website
Also see my site > website
Bowflex revolution has a built-in rowing machine.
Review my web blog :: http://thefitnessguide.org/
my website - thefitnessguide.org
Hi there, it’s understandable piece of writing along with this YouTube video; I can’t imagine that one can not understand this straightforward piece
of writing having with video demo.
Also visit my blog; website
Hello, its fastidious post concerning media print, we all understand media is
a fantastic source of facts.
Also visit my site :: http://www.myarticles.gr/The-Diverse-Features-Of-The-Inversion-Table.htm
If you want to get much from this piece of writing
then you have to apply such techniques to your
won webpage.
Feel free to visit my web blog weblife.es
Hello dear, are you enjoying with this humorous YouTube video?
Hmmm, that’s good, I am also watching this YouTube joke video at the moment.
Here is my website; welovedthis.com
he blog was how do i say it… relevant, finally something that helped me.
Thanks
Visit my web blog; vma-211avengers.com
That’s Too nice, when it comes in india hope it can make a Rocking place for youngster.
. hope that come true.
My page; http://www.pressace.com/Use-Coupons-For-Added-Gains.htm
Okay you are true, YouTube is best video distribution site,
as YouTube is a lightly no much streaming time rather than other web sites.
My weblog http://iveg.com/Leora8781
Hello, how’s it going? Just shared this post with a colleague, we had a good laugh.
My blog post; sharewithpeople.com
My webpage - www.weblearningit.com
all the time i used to read smaller articles that also clear their
motive, and that is also happening with this piece of writing which I am reading here.
Stop by my web page http://www.ausfaces.com.au/index.php?do=/blog/122837/strategies-to-use-coupons-to-ones-benefit/
I love your blog.. very nice colors & theme.
Did you create this website yourself?
Plz reply back as I’m looking to create my own blog and would like to
know wheere u got this from. thanks
my site: website
Hi colleagues, is there any other fastidious blog related to
JavaScript articles, while this one is good for PHP programming.
Look at my weblog :: redshanty.com
I am keen of learning Flash, is there any piece of writing related to
Flash, if okay, then please post it, thanks.
Here is my web-site :: ineedabeer.us
my website: website
It sounds like you're creating problems yourself by trying to solve this issue instead of looking at why their is a problem in the first place.
Feel free to surf to my web-site; website
What’s up to every one, as I am in fact eager of reading this web site’s post to
be updated regularly. It includes nice stuff.
Feel free to surf to my web blog website
Hello, its fastidious post concerning media print, we all understand media is a fantastic source
of facts.
Here is my homepage: website
Hello dear, me plus my mom are as well watch comical video clips except after I
done my homework
Also visit my weblog - http://arjoboled.site90.net
Please upload more movies related to cooking if you have, for the reason that I would like to learn more and more about
all recipes of cooking.
Check out my blog post ... http://onlinechatroom.org/index.php?do=/blog/45814/1-methods-to-use-coupon-discounts
Thanks in support of sharing such a pleasant opinion, piece of writing is fastidious, thats why i have read it fully
Look into my webpage: website
Wow! what an idea ! What a concept ! Beautiful .. Amazing …
Have a look at my web blog :: outbacknomads.timdiekman.com
my web page > website
Nice post! GA is also my biggest earning. However, it’s not a much.
Visit my webpage ... website
My site - thinkstr.com
I always download a full show in parts, that’s always present at YouTube, since my network connection
is extremely slow and YouTube fulfils my wishes.
Here is my web page; website
If you apply these kinds of methods for increasing traffic on your own webpage, I am sure you will notice the change in few days.
Also visit my web-site: www.ncsmed.org.fj
my webpage > openarticle.co.uk
I don’t waste my free time in watching movies except
I go for to read posts on net and get updated from newest technologies.
Look at my web page articleinternet.info
My web page > website
my God, i thought you were going to chip in with some decisive insght at the end there,
not leave it with ‘we leave it to you to decide’.
Feel free to surf to my blog post - http://thundershadcrankbaits.com/index.php?option=com_blog&view=comments&pid=28620&Itemid=0
This piece of writing offers clear idea designed for the new users of blogging, that genuinely how to do blogging
and site-building.
Feel free to surf to my weblog www.sme-community.com
Come on dude, these facts* and proof* i mean who is posting* lol :P
Feel free to surf to my homepage :: wesite
thanks !! very helpful post!
Feel free to visit my web blog - face2face.me
This paragraph is related to web programming is in fact good in favor of me as I am web developer.
Thanks for sharing keep it up.
Have a look at my blog post ... http://bluebirdseasonaire.com
When someone writes an piece of writing he/she retains the thought
of a user in his/her brain that how a user can know it.
Therefore that’s why this piece of writing
is outstdanding. Thanks!
My web site: http://petghar.com
my webpage > http://postrenterrewards.net
There is obviously a lot to know about this. I think you made some good points in Features also.
My web page - englishliterature.co
There are also so many video uploading sites, and these also give facility for distribution their video tutorials, except I think YouTube is the most excellent.
my site :: www.allnews-info.com
Having read this I thought it was very informative. I appreciate
you taking the time and effort to put this article together.
I once again find myself spending way to much time both reading and commenting.
But so what, it was still worth it!
Review my blog post - outdoorshoppingguide.com
This is a very good tips especially to those new to blogosphere, brief and accurate
information… Thanks for sharing this one. A must read article.
Feel free to surf to my weblog :: social
Also see my page - http://hostmountain.org/
Неllo there! Τhіѕ
агtіcle сoulԁn't be written any better! Going through this post reminds me of my previous roommate! He continually kept talking about this. I'll fоrωard
thіs post to him. Pretty ѕurе he'll have a very good read. Thanks for sharing! Recommended Web-site
Always, the typical buyers of shopping web sites may get more benefits from the shops when compared
to the common or guest customers.
Also visit my homepage ... http://dealsontheweb.org/tire-rack/
Ab circle pro on good discounts
Review my blog post; diethub.org
buy valium buy valium india - buy valium online thailand
Hello! I'm at work surfing around your blog from my new apple iphone! Just wanted to say I love reading through your blog and look forward to all your posts! Keep up the excellent work! profilarena.craiovatracker.com
For moѕt uр-to-date newѕ you
have to vіsit internet and on world-wide-web
I found this website aѕ a best web site for latest updаtеs.
Learn Even more Here
We stumbled ovеr heгe coming frοm a different pаge and thought Ι may as well check thіngs out.
I like what I see ѕo noω i am folloωing you.
Look forward to looking oνer yοur web ρage yеt again.
http://www.pianotut.com/learn-piano-notes/
ӏ'm excited to find this site. I need to to thank you for ones time just for this fantastic read!! I definitely liked every bit of it and i also have you book-marked to see new things in your website. expand
Mаgnificent itеms frоm yоu, man.
I've take note your stuff prior to and you'гe sіmply
too fаntаstic. І гeallу likе whаt you havе obtaіned right here,
certaіnly liκe what you arе stating аnd the way through which you saу it.
You mаκе it еnjoyable anԁ уou still take care of to keеp іt
wise. I cant wait to read much more from you.
Thiѕ is really a terrific ωeb ѕitе.
www.greatsinginglessons.com
Gгeat blog you have herе but I wаs wаnting to know іf yоu kneω of anу uѕeг disсussion fогums thаt cover the sаme topics talked
about in this article? I'd really like to be a part of community where I can get suggestions from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Appreciate it! www.growtallermaster.com/growing-taller-secrets/
Attractіve element of content. I ѕimρly stumblеd upon yοur site
and in acсession capіtal to сlаіm that I get in fаct enjoyеd account уour blog ρoѕts.
Anу way I will bе subscribing to your feeԁs and еven Ι fulfіllment you get right οf еntry to рeгsistentlу fast.
http://Www.Thegametester.com/become-a-game-tester/
Thanks in favor of sharing such a plеasant thought,
post іs nice, thats why i hаvе read it fully click here
What a funny blog! I actually loved watching this comic video
with my family as well as including my mates.
My weblog :: social
Its my destiny to visit at this blog and find out
my required paragraph along with video demo, that’s YouTube
video and its also in quality.
my web site yourskincareguide.com
I got good info from your blog
My blog; http://crossdeals.net/shoebuy/
Hurrah! Its also pleasant post about JavaScript,
I am in fact keen of learning JavaScript. thanks admin
my blog post - http://hostcircle.org/hostgator/
I read this post completely concerning the difference of latest and previous technologies,
it’s awesome article.
my blog post - fatcow
Hi colleagues, is there any other fastidious blog related to
JavaScript articles, while this one is good for PHP programming.
Feel free to surf to my web-site - yourhealthzone.org
This webpage is containing a pleasant stuff of humorous YouTube
video lessons, I loved it a lot.
Look at my blog social
Can you please send by e-mail me the code for this script or please
tell me in detail concerning this script?
my site anxiety treatment
Sharing some thing is better than keeping up-to our self,
thus the YouTube video that is posted at this time I am going
to share through my family and mates.
Also visit my web site http://yourhostingguide.org/
Also see my website :: social
Post a Comment