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 1162: FROM mtl_system_items msi

1158: begin
1159:
1160: SELECT msi.revision_qty_control_code
1161: INTO x_item_rev_control
1162: FROM mtl_system_items msi
1163: WHERE msi.inventory_item_id = x_item_id
1164: AND msi.organization_id = x_using_organization_id;
1165: exception
1166: when no_data_found then

Line 4769: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;

4765:
4766: --
4767: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4768: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4769: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4770: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4771: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4772: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4773: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;

Line 4770: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;

4766: --
4767: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4768: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4769: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4770: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4771: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4772: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4773: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;
4774: l_uom_conversion_rate NUMBER;

Line 4771: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;

4767: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4768: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4769: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4770: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4771: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
4772: l_min_ord_qty PO_ASL_ATTRIBUTES.min_order_qty%type;
4773: l_fixed_lot_multiple PO_ASL_ATTRIBUTES.fixed_lot_multiple%type;
4774: l_uom_conversion_rate NUMBER;
4775: l_enforce_full_lot_qty PO_SYSTEM_PARAMETERS.enforce_full_lot_quantities%type;

Line 5006: FROM mtl_system_items msi

5002: IF (x_item_id IS NOT NULL) THEN
5003:
5004: SELECT msi.buyer_id
5005: INTO x_buyer_id
5006: FROM mtl_system_items msi
5007: WHERE msi.inventory_item_id = x_item_id
5008: AND msi.organization_id = x_organization_id;
5009:
5010: x_item_buyer_id := x_buyer_id;

Line 5127: FROM mtl_system_items msi

5123:
5124: BEGIN
5125: SELECT msi.primary_unit_of_measure, msi.rounding_factor
5126: INTO l_primary_uom, l_rounding_factor
5127: FROM mtl_system_items msi
5128: WHERE msi.inventory_item_id = x_item_id
5129: AND msi.organization_id = x_organization_id;
5130: EXCEPTION
5131: WHEN OTHERS THEN

Line 5361: FROM mtl_system_items msi

5357:
5358: BEGIN
5359: SELECT msi.primary_unit_of_measure, msi.rounding_factor, msi.unit_of_issue
5360: INTO l_primary_uom, l_rounding_factor, l_unit_of_issue
5361: FROM mtl_system_items msi
5362: WHERE msi.inventory_item_id = x_item_id
5363: AND msi.organization_id = x_source_organization_id;
5364: EXCEPTION
5365: WHEN OTHERS THEN

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

5374: --* We retrieve and apply order modifiers
5375: -- 1. if primary_uom of the item is same as the UOM mentioned on the requisition
5376: -- 2. if requisitions are generated from Inventory(Interface source code = 'INV')
5377:
5378: --* The values from MTL_ITEM_SUB_INVENTORIES take precedence over MTL_SYSTEM_ITEMS.
5379:
5380: IF (l_primary_uom = x_unit_of_measure
5381: AND l_interface_source_code = 'INV')THEN
5382:

Line 5406: FROM MTL_SYSTEM_ITEMS msi

5402: BEGIN
5403: SELECT nvl(l_fixed_lot_multiple,msi.fixed_lot_multiplier),
5404: nvl(l_min_ord_qty, msi.minimum_order_quantity)
5405: INTO l_fixed_lot_multiple, l_min_ord_qty
5406: FROM MTL_SYSTEM_ITEMS msi
5407: WHERE msi.inventory_item_id = x_item_id
5408: AND msi.organization_id = x_source_organization_id;
5409: EXCEPTION
5410: WHEN NO_DATA_FOUND THEN

Line 5469: x_item_id IN Mtl_system_items.inventory_item_id%type,

5465: * vendor sites and Asl ids from the global Asl.
5466: */
5467:
5468: Procedure Get_All_Item_Asl(
5469: x_item_id IN Mtl_system_items.inventory_item_id%type,
5470: x_using_organization_id IN Number, --will be -1
5471: X_vendor_details IN OUT NOCOPY PO_AUTOSOURCE_SV.vendor_record_details,
5472: x_return_status OUT NOCOPY varchar2,
5473: x_msg_count OUT NOCOPY Number,