When we are define Modifier in the OM module. We can define Modifier at the particular Item or all the Items in the Price List/Item Category etc. Note:- Item Category is the Flex-field in the Inventory Module. In the Master Item define, we choose what item belongs to which Item Category. The following query will […]
When we are define Modifier in the OM module. We can define Modifier at the particular Item or all the Items in the Price List/Item Category etc. Note:- Item Category is the Flex-field in the Inventory Module. In the Master Item define, we choose what item belongs to which Item Category. The following query will […]
Following Query would get all the PO Numbers, Item ID, Quantity Order, Received, Canceled etc. The same information can be found in the PO order form from the Front end Application. SELECTPOL.ITEM_ID “Inventory Item ID”,POLL.SHIP_TO_LOCATION_ID “Ship to Location ID”,poll.quantity “Quantity”,poll.Quantity_received “Quantity Received”,poll.QUANTITY_cancelled “Quantity Canceled”,POH.SEGMENT1 “PO Order Number”FROM po_headers_all poh, po_lines_all pol, po_line_locations_all pollWHERE poh.po_header_id=pol.po_header_idAND pol.po_line_id=poll.po_line_idAND […]
The following query gets the information about the Lot Numbers of Assembly Completion. Note:- I have commented “mmt.organization_id = your_organization_id” condition. If you want to get the results specific to some inventory organization then, you can use this condition. Organization_id is representing the Inventory Organization. SELECT mmt.transaction_id , mmt.transaction_date , mmt.inventory_item_id , mmt.organization_id , mtn.lot_number […]
With the following query you can know what all the permissions you have for any Specific Application User. I have used this query when working on some custom page. Based on the permissions given to the User, you can provide some additional functionality to the Users. Note:- I have commented out the permission name. in […]
Recent Comments