APPS.PO_REQIMP_S dependencies on MTL_SYSTEM_ITEMS

Line 62: FROM mtl_system_items msi

58: If (x_list_price_conv_temp < 0) then
59:
60: update po_requisitions_interface
61: set unit_price = (select msi.list_price_per_unit
62: FROM mtl_system_items msi
63: WHERE msi.inventory_item_id = x_item_id
64: AND msi.organization_id = x_source_org_id)
65: where rowid = x_rowid;
66:

Line 71: FROM mtl_system_items msi

67: else
68:
69: update po_requisitions_interface
70: set unit_price = (select ( msi.list_price_per_unit * x_list_price_conv_temp)
71: FROM mtl_system_items msi
72: WHERE msi.inventory_item_id = x_item_id
73: AND msi.organization_id = x_source_org_id)
74: where rowid = x_rowid;
75: end if;

Line 122: FROM mtl_system_items msi

118: --This is done to avoid inaccurate value after conversion.
119: --SELECT round(po_uom_s.po_uom_convert(msi.primary_unit_of_measure, x_uom, x_item_id),10)
120: SELECT round(po_uom_s.po_uom_convert(x_uom, msi.primary_unit_of_measure, x_item_id),10)
121: INTO x_uom_conversion_temp
122: FROM mtl_system_items msi
123: WHERE msi.inventory_item_id = x_item_id
124: AND x_inventory_org_id = msi.organization_id
125: AND msi.primary_unit_of_measure <> x_uom;
126: EXCEPTION

Line 140: FROM mtl_system_items msi,

136: --List price is multiplied with uom conversion instead of dividing.
137: --This is done to avoid inaccurate value after conversion.
138: --SET pri.unit_price = (SELECT round(msi.list_price_per_unit / (x_uom_conversion_temp),10)
139: SET pri.unit_price = (SELECT round(msi.list_price_per_unit * (x_uom_conversion_temp),10)
140: FROM mtl_system_items msi,
141: po_line_types plt
142: WHERE msi.inventory_item_id = pri.item_id
143: AND x_inventory_org_id
144: = msi.organization_id

Line 331: l_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;

327: l_row_id ROWID;
328:
329:
330: l_item_um2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
331: l_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
332: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
333: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
334:
335:

Line 332: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;

328:
329:
330: l_item_um2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
331: l_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
332: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
333: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
334:
335:
336: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

Line 333: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;

329:
330: l_item_um2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
331: l_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
332: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
333: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
334:
335:
336: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
337: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 338: l_tracking_qty_ind_s MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;

334:
335:
336: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
337: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
338: l_tracking_qty_ind_s MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
339: l_secondary_default_ind_s MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
340: l_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
341:
342: l_sec_qty_source NUMBER;

Line 339: l_secondary_default_ind_s MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;

335:
336: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
337: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
338: l_tracking_qty_ind_s MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
339: l_secondary_default_ind_s MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
340: l_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
341:
342: l_sec_qty_source NUMBER;
343:

Line 365: From mtl_system_items m

361: Cursor Cr_item_attr(p_inv_item_id IN NUMBER,p_organization_id IN NUMBER) IS
362: Select m.tracking_quantity_ind,
363: m.secondary_uom_code,
364: m.secondary_default_ind
365: From mtl_system_items m
366: Where m.inventory_item_id = p_inv_item_id
367: And m.organization_id = p_organization_id;
368:
369: BEGIN