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

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

Line 141: FROM mtl_system_items msi,

137: --Bug#11668528 Start
138: BEGIN
139: SELECT round(msi.list_price_per_unit * (x_uom_conversion_temp),10)
140: INTO x_list_price
141: FROM mtl_system_items msi,
142: po_line_types plt
143: WHERE msi.inventory_item_id = x_item_id
144: AND msi.organization_id = x_destination_org_id
145: AND plt.line_type_id = x_line_type_id

Line 156: FROM mtl_system_items msi,

152: IF x_list_price IS NULL THEN
153: BEGIN
154: SELECT round(msi.list_price_per_unit * (x_uom_conversion_temp),10)
155: INTO x_list_price
156: FROM mtl_system_items msi,
157: po_line_types plt
158: WHERE msi.inventory_item_id = x_item_id
159: AND msi.organization_id = x_inventory_org_id
160: AND plt.line_type_id = x_line_type_id

Line 176: FROM mtl_system_items msi,

172: --This is done to avoid inaccurate value after conversion.
173: --SET pri.unit_price = (SELECT round(msi.list_price_per_unit / (x_uom_conversion_temp),10)
174: --Commented below to update price with x_list_price Bug# 11668528
175: /* SET pri.unit_price = (SELECT round(msi.list_price_per_unit * (x_uom_conversion_temp),10)
176: FROM mtl_system_items msi,
177: po_line_types plt
178: WHERE msi.inventory_item_id = pri.item_id
179: AND pri.DESTINATION_ORGANIZATION_ID
180: = msi.organization_id

Line 368: l_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;

364: l_row_id ROWID;
365:
366:
367: l_item_um2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
368: l_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
369: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
370: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
371:
372:

Line 369: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;

365:
366:
367: l_item_um2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
368: l_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
369: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
370: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
371:
372:
373: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

Line 370: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;

366:
367: l_item_um2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
368: l_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE;
369: l_tracking_qty_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
370: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
371:
372:
373: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
374: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

Line 375: l_tracking_qty_ind_s MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;

371:
372:
373: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
374: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
375: l_tracking_qty_ind_s MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
376: l_secondary_default_ind_s MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
377: l_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
378:
379: l_sec_qty_source NUMBER;

Line 376: l_secondary_default_ind_s MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;

372:
373: l_item_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
374: l_item_um2_s MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
375: l_tracking_qty_ind_s MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
376: l_secondary_default_ind_s MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE;
377: l_unit_of_measure_s MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
378:
379: l_sec_qty_source NUMBER;
380:

Line 402: From mtl_system_items m

398: Cursor Cr_item_attr(p_inv_item_id IN NUMBER,p_organization_id IN NUMBER) IS
399: Select m.tracking_quantity_ind,
400: m.secondary_uom_code,
401: m.secondary_default_ind
402: From mtl_system_items m
403: Where m.inventory_item_id = p_inv_item_id
404: And m.organization_id = p_organization_id;
405:
406: BEGIN