eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AUTOSOURCE_SV dependencies on MTL_SYSTEM_ITEMS

Line 183: FROM mtl_system_items msi

179:
180: BEGIN
181: SELECT msi.buyer_id
182: INTO x_buyer_id
183: FROM mtl_system_items msi
184: WHERE msi.inventory_item_id = x_item_id
185: AND msi.organization_id = x_organization_id;
186:
187: x_item_buyer_id := x_buyer_id; -- FPI GA

Line 198: --bug#3048965 if the buyer id in mtl_system_items table is null then

194: WHEN NO_DATA_FOUND THEN
195: x_buyer_id := NULL;
196: x_item_buyer_id := NULL;
197: END;
198: --bug#3048965 if the buyer id in mtl_system_items table is null then
199: --we make an attempt to default it from the po_agents table
200: --if there is only one buyer defined for the category associated
201: --with the Purchasing category set of the concerned item.
202: IF(x_buyer_id is null)THEN

Line 1166: FROM mtl_system_items msi

1162: begin
1163:
1164: SELECT msi.revision_qty_control_code
1165: INTO x_item_rev_control
1166: FROM mtl_system_items msi
1167: WHERE msi.inventory_item_id = x_item_id
1168: AND msi.organization_id = x_using_organization_id;
1169: exception
1170: when no_data_found then

Line 4807: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;

4803:
4804: --
4805: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4806: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4807: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4808: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4809: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4810: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4811: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;

Line 4808: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;

4804: --
4805: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4806: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4807: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4808: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4809: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4810: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4811: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;
4812: l_uom_conversion_rate NUMBER;

Line 4809: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;

4805: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4806: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4807: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4808: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4809: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4810: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4811: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;
4812: l_uom_conversion_rate NUMBER;
4813: l_enforce_full_lot_qty PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%type;

Line 5048: FROM mtl_system_items msi

5044: IF (x_item_id IS NOT NULL) THEN
5045:
5046: SELECT msi.buyer_id
5047: INTO x_buyer_id
5048: FROM mtl_system_items msi
5049: WHERE msi.inventory_item_id = x_item_id
5050: AND msi.organization_id = x_organization_id;
5051:
5052: x_item_buyer_id := x_buyer_id;

Line 5169: FROM mtl_system_items msi

5165:
5166: BEGIN
5167: SELECT msi.primary_unit_of_measure, msi.rounding_factor
5168: INTO l_primary_uom, l_rounding_factor
5169: FROM mtl_system_items msi
5170: WHERE msi.inventory_item_id = x_item_id
5171: AND msi.organization_id = x_organization_id;
5172: EXCEPTION
5173: WHEN OTHERS THEN

Line 5438: FROM mtl_system_items msi

5434:
5435: BEGIN
5436: SELECT msi.primary_unit_of_measure, msi.rounding_factor, msi.unit_of_issue
5437: INTO l_primary_uom, l_rounding_factor, l_unit_of_issue
5438: FROM mtl_system_items msi
5439: WHERE msi.inventory_item_id = x_item_id
5440: AND msi.organization_id = x_source_organization_id;
5441: EXCEPTION
5442: WHEN OTHERS THEN

Line 5455: --* The values from MTL_ITEM_SUB_INVENTORIES take precedence over MTL_SYSTEM_ITEMS.

5451: --* We retrieve and apply order modifiers
5452: -- 1. if primary_uom of the item is same as the UOM mentioned on the requisition
5453: -- 2. if requisitions are generated from Inventory(Interface source code = 'INV')
5454:
5455: --* The values from MTL_ITEM_SUB_INVENTORIES take precedence over MTL_SYSTEM_ITEMS.
5456:
5457: IF (l_primary_uom = x_unit_of_measure
5458: AND l_interface_source_code = 'INV')THEN
5459:

Line 5483: FROM MTL_SYSTEM_ITEMS msi

5479: BEGIN
5480: SELECT nvl(l_fixed_lot_multiple,msi.fixed_lot_multiplier),
5481: nvl(l_min_ord_qty, msi.minimum_order_quantity)
5482: INTO l_fixed_lot_multiple, l_min_ord_qty
5483: FROM MTL_SYSTEM_ITEMS msi
5484: WHERE msi.inventory_item_id = x_item_id
5485: AND msi.organization_id = x_source_organization_id;
5486: EXCEPTION
5487: WHEN NO_DATA_FOUND THEN

Line 5546: x_item_id IN Mtl_system_items.inventory_item_id%type,

5542: * vendor sites and Asl ids from the global Asl.
5543: */
5544:
5545: Procedure Get_All_Item_Asl(
5546: x_item_id IN Mtl_system_items.inventory_item_id%type,
5547: x_using_organization_id IN Number, --will be -1
5548: X_vendor_details IN OUT NOCOPY PO_AUTOSOURCE_SV.vendor_record_details,
5549: x_return_status OUT NOCOPY varchar2,
5550: x_msg_count OUT NOCOPY Number,