DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on MTL_SYSTEM_ITEMS_TL

Line 2053: mtl_system_items_tl msitl,

2049: decode(p1.item_description, 'ITEM_NONE_ENTERED', msitl.description, p1.item_description),
2050: msi.allow_item_desc_update_flag,
2051: decode(p1.unit_of_measure, 'UOM_NONE_ENTERED', uom.unit_of_measure_tl, p1.unit_of_measure)
2052: from mtl_system_items_kfv msi,
2053: mtl_system_items_tl msitl,
2054: mtl_units_of_measure_tl uom
2055: where msi.concatenated_segments = p1.item_number and
2056: msi.organization_id = l_inventory_org_id and
2057: nvl(msi.outside_operation_flag, 'N') = nvl(p1.outside_operation_flag, 'N') and

Line 2109: mtl_system_items_tl msitl

2105: item_number is not null and
2106: allow_item_desc_update_flag = 'N' and
2107: item_description <> (select msitl.description
2108: from mtl_system_items_kfv msi,
2109: mtl_system_items_tl msitl
2110: where msi.inventory_item_id = p1.item_id and
2111: msi.organization_id = l_inventory_org_id and
2112: msi.inventory_item_id = msitl.inventory_item_id and
2113: msi.organization_id = msitl.organization_id and